pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

sql function examples requested (! select)
2+ messages / 2 participants
[nested] [flat]

* sql function examples requested (! select)
@ 2002-08-14 16:39  Sue Humphrey <sue_humphrey@yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Sue Humphrey @ 2002-08-14 16:39 UTC (permalink / raw)
  To: pgsql-sql

I would like examples of functions using update, insert and
delete, where LANGUAGE 'SQL', both how to write them and how to
use them.

I've got examples of functions as selects coming out of my ears,
and PL/pgsql examples of more complex needs, but I just need to
run a simple UPDATE.  And I forsee an immediate need to do
deletes the same way.

Please feel free to either respond to the list, or in email, as
I subscribe to both.

Sue

__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: sql function examples requested (! select)
@ 2002-08-14 17:25  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Sue Humphrey <sue_humphrey@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2002-08-14 17:25 UTC (permalink / raw)
  To: Sue Humphrey <sue_humphrey@yahoo.com>; +Cc: pgsql-sql

Sue Humphrey <sue_humphrey@yahoo.com> writes:
> I would like examples of functions using update, insert and
> delete, where LANGUAGE 'SQL', both how to write them and how to
> use them.

Have you read the documentation?

http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/xfunc-sql.html

The first couple of examples seem to cover the territory ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-08-14 17:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-08-14 16:39 sql function examples requested (! select) Sue Humphrey <sue_humphrey@yahoo.com>
2002-08-14 17:25 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox