Re: [PATCHES] Clarify use of NOW() in pl/pgsql docs

2005-02-10 Thread Peter Eisentraut
Tom Lane wrote: > Considering that the example in question is embedded in the > 100%-not-SQL- standard language plpgsql, I can't get excited about > this either. I was under the impression that our PL/pgSQL is at least partially an attempt to implement SQL:2003, part 4. -- Peter Eisentraut http

Re: [PATCHES] Clarify use of NOW() in pl/pgsql docs

2005-02-10 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > I was under the impression that our PL/pgSQL is at least partially an > attempt to implement SQL:2003, part 4. No, it's an attempt to emulate Oracle's PL/SQL. Any similarity to spec documents dated later than the original creation of plpgsql (1998)

Re: [PATCHES] Clarify use of NOW() in pl/pgsql docs

2005-02-10 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > On Thu, 2005-02-10 at 16:32 +0900, Michael Glaesemann wrote: >> I realize it's a bit late, but it might not be a bad idea to use >> CURRENT_TIMESTAMP rather than NOW(), as it's per SQL spec. > I can't say I can get very excited about it; someone is free t

Re: [PATCHES] Clarify use of NOW() in pl/pgsql docs

2005-02-10 Thread Neil Conway
On Thu, 2005-02-10 at 16:32 +0900, Michael Glaesemann wrote: > I realize it's a bit late, but it might not be a bad idea to use > CURRENT_TIMESTAMP rather than NOW(), as it's per SQL spec. I can't say I can get very excited about it; someone is free to submit a patch if they like. -Neil -

Re: [PATCHES] Clarify use of NOW() in pl/pgsql docs

2005-02-10 Thread Christopher Kings-Lynne
This one from Ben Calvert. It uses the (imho clearer) NOW() rather than 'NOW' in a PL/PgSQL function example. Applied, thanks. Why not use CURRENT_TIMSTAMP instead of NOW() everywhere in the docs. I mean, it's standard and NOW() isn't... Chris ---(end of broadcast)-

Re: [PATCHES] Clarify use of NOW() in pl/pgsql docs

2005-02-09 Thread Michael Glaesemann
On Feb 10, 2005, at 14:00, Neil Conway wrote: On Thu, 2005-01-27 at 02:28 -0800, David Fetter wrote: This one from Ben Calvert. It uses the (imho clearer) NOW() rather than 'NOW' in a PL/PgSQL function example. Applied, thanks. I realize it's a bit late, but it might not be a bad idea to use CURR

Re: [PATCHES] Clarify use of NOW() in pl/pgsql docs

2005-02-09 Thread Neil Conway
On Thu, 2005-01-27 at 02:28 -0800, David Fetter wrote: > This one from Ben Calvert. It uses the (imho clearer) NOW() rather > than 'NOW' in a PL/PgSQL function example. Applied, thanks. -Neil ---(end of broadcast)--- TIP 3: if posting/reading th

[PATCHES] Clarify use of NOW() in pl/pgsql docs

2005-01-27 Thread David Fetter
Folks, This one from Ben Calvert. It uses the (imho clearer) NOW() rather than 'NOW' in a PL/PgSQL function example. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/plpgsql.sgml ==