Re: [SQL] Variable number or arguments to a function possible?

2009-04-24 Thread Tom Lane
Chris Ruprecht writes: > Is it possible to create a function that can take a variable number of > arguments? No, but you can make it take an array and then write something like myfunc(array[x, y, ...]) 8.4 will have some syntactic sugar that looks like variable numbers of arguments, b

Re: [SQL] Variable number or arguments to a function possible?

2009-04-24 Thread Milen A. Radev
Chris Ruprecht написа: > Hello everybody, > > Is it possible to create a function that can take a variable number of > arguments? > I would like to write a function that creates a new record in the > database. Based on what I send it, it should create a record in the > appropriate table. > > Simp

[SQL] Variable number or arguments to a function possible?

2009-04-24 Thread Chris Ruprecht
Hello everybody, Is it possible to create a function that can take a variable number of arguments? I would like to write a function that creates a new record in the database. Based on what I send it, it should create a record in the appropriate table. Simple pseudo-code example: ... func

Re: [SQL] varchar value comparisons not working?

2009-04-24 Thread Tom Lane
Shawn Tayler writes: > I run the following: > select sfd.lid as sflid,sd.lid as slid,sfd.serial from sfd,shawns_data > sd where sfd.serial = sd.serial_number order by sfd.lid; > the lid columns in both tables should be identical, but as you see in > this sample, they do differ: > sflid | slid

[SQL] varchar value comparisons not working?

2009-04-24 Thread Shawn Tayler
Hello, I'm doing a quick comparison between a couple tables, trying to cleanup some inconsistencies, and what should be a simple check between 2 tables doesn't seem to be working. psql is 8.3.7 and server is 8.2.13. I run the following: select sfd.lid as sflid,sd.lid as slid,sfd.serial from sfd