[SQL] Max input parameter for a function

2003-10-19 Thread Kumar
Dear friends,   While trying to allocate about 36 input parameters, I got an error saying that the max input parameter for a function is only 32.   Is it right? How to overcome this? Because I wanna insert records into a table of 55 columns with a lot of NULL able columns.   I am using Postgr

Re: [SQL] Which is faster SQL or PL/PGSQL

2003-10-19 Thread Josh Berkus
George, > i am converting an MSSQL database to Postgres. there is a lot of procedures > to convert. > > which language is best for functions, SQL or plpgsql. If you're porting from T-SQL, you should use PL/pgSQL. However, you will have to re-code many of your procedures by hand, as T-SQL and PL

Re: [SQL] Which is faster SQL or PL/PGSQL

2003-10-19 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] ("George A.J") wrote: > i am converting an MSSQL database to Postgres. there is a lot of procedures to > convert. > > which language is best for functions, SQL or plpgsql. > > which is faster . i am using postgres 7.3.2 Hmm? This doesn't seem to make much

[SQL] Which is faster SQL or PL/PGSQL

2003-10-19 Thread George A.J
hi, i am converting an MSSQL database to Postgres. there is a lot of procedures to convert. which language is best for functions, SQL or plpgsql. which is faster . i am using postgres 7.3.2 jinujose Do you Yahoo!? The New Yahoo! Shopping - with improved product search

[SQL] date_trunc for 5 minutes intervals

2003-10-19 Thread email lists
Hi All, I am wanting to perform the equivalent of date_trunc to 5/10/15 minute intervals. As this does mnot seem to be natively supported by date_trunc, can anyone point me in the right direction to possible write the SQL ro acheive the desired outcome? Tia, Darren ---(e