[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

Re: [SQL] varchar value comparisons not working?

2009-04-24 Thread Tom Lane
Shawn Tayler stay...@washoecounty.us 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

[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: ...

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. Simple

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

2009-04-24 Thread Tom Lane
Chris Ruprecht ch...@ruprecht.org 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