[GENERAL] PL/pgSQL syntax/usage question

2000-02-01 Thread Henk van Lingen
Hi *, I'm starting with PL/pgSQL but can't exactly find out how to do something like this: CREATE FUNCTION textkey (text, int4) RETURNS text AS ' DECLARE tabel ALIAS FOR $1; id ALIAS FOR $2; result record; BEGIN sele

[GENERAL]

2000-02-01 Thread Arnaud FLORENT
hello, i'm trying to use -s flag with postgres but i can't find where those stats are printed. any help? -- __ Arnaud FLORENT IRIS Technologies phone: (33) 03 20 65 85 80 fax: (33) 03 20 65 85 81 GSM: (33) 06 15 14 32 90 mailto:[EMAIL PROTECTED] __

Re: [GENERAL] Use of datepart() on TimeStamp.

2000-02-01 Thread Karel Zak - Zakkr
On Tue, 1 Feb 2000, Jose Soares wrote: > I suppose do you refer to PostgreSQL date_part() function, while datepart() is a > M$Access function. Sorry, next time I read it better... Hmm, datepart/date_part, it is very simular - IMHO any Micro$oft surely copy this function from the best SQL - f