Re: [SQL] sql function examples requested (! select)

2002-08-14 Thread Tom Lane
Sue Humphrey <[EMAIL PROTECTED]> 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 fi

[SQL] sql function examples requested (! select)

2002-08-14 Thread Sue Humphrey
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