Re: [SQL] generic return for functions

2003-06-02 Thread Avi Schwartz
eSQL developers, thank you for a great product! Avi -- Avi Schwartz [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] generic return for functions

2003-06-02 Thread Avi Schwartz
. The default value is used when the parameter is NULL or unprovided? fn(integer, integer, integer default 32) select fn(integer, integer); <- Third argument would be '32'? When PostgreSQL gets named parameters the above probably makes sense to add. A TODO item? -- Avi Schwartz [EM

Re: [SQL] generic return for functions

2003-06-01 Thread Avi Schwartz
etter way? Something that's like "returns setof record" but without having to define all the columns when I call the function? {i.e. without the need to do: select * from myfunction() as (column1 type1, column2...);} If there is such method? It will allow me to maintain the applic