[SQL] function returning resultset

2004-03-12 Thread William Anthony Lim
Hi, I'm using PGSQL 7.4.1 and JDBC 75dev client. I want to ask about PL/PGSQL function returning resultset. I read in the docs, there are 'setof' and 'refcursor' method, is there another method to returning resultset? What advantages and disadvantages for each method? Which is the best? Plz exp

[SQL] pg_dump backwards compat issues

2004-03-12 Thread tomg
Hi all, anybody have a sed script (or flags for pg_dump) that will make a pg_dump 7.4 dump load into a Pg 7.3.x backend? TIA! --- Thomas Good e-mail: [EMAIL PROTECTED] Programmer/Analyst

Re: [SQL] SQL query --- big question???

2004-03-12 Thread Richard Huxton
On Friday 12 March 2004 14:36, Andrei Bintintan wrote: > Hi to all, > > I have a big question. > > Can I write a query/function/agregate function (whatever) so that I can > return the result of a query in a single line? I don't know if this is > possible to be made and please if it is not possible

Re: [SQL] sqlloader features

2004-03-12 Thread Jeff Eckermann
--- [EMAIL PROTECTED] wrote: > Hi , > > >does postgresql support for the sql loader > functionality like oracle > does ??? if no, is there any tools specific to do > this task connect to > postgresql database??? > i'm looking into open-source tools that can do > import & export facility. >

[SQL] SQL query --- big question???

2004-03-12 Thread Andrei Bintintan
Hi to all,   I have a big question.   Can I write a query/function/agregate function (whatever) so that I can return the result of a query in a single line? I don't know if this is possible to be made and please if it is not possible please say.     I better give an example:   table (id, nam

Re: [SQL] where not unique

2004-03-12 Thread Paul Thomas
On 12/03/2004 13:02 Gary Stainburn wrote: Hi folks, I've got a table which contains amongst other things a stock number and a registration number. I need to print out a list of stock number and reg number where reg number is not unique (cherished number plate transfer not completed). I've tried

Re: [SQL] where not unique

2004-03-12 Thread Daniel Henrique Alves Lima
You're right, Reinoud. Sorry for my mystake... Reinoud van Leeuwen wrote: On Fri, Mar 12, 2004 at 10:54:25AM -0300, Daniel Henrique Alves Lima wrote: Gary Stainburn wrote: Hi folks, I've got a table which contains amongst other things a stock number and a registration number. I need t

Re: [SQL] where not unique

2004-03-12 Thread Daniel Henrique Alves Lima
Gary Stainburn wrote: Hi folks, I've got a table which contains amongst other things a stock number and a registration number. I need to print out a list of stock number and reg number where reg number is not unique (cherished number plate transfer not completed). I've tried variations of a

[SQL] where not unique

2004-03-12 Thread Gary Stainburn
Hi folks, I've got a table which contains amongst other things a stock number and a registration number. I need to print out a list of stock number and reg number where reg number is not unique (cherished number plate transfer not completed). I've tried variations of a theme based on select

[SQL] sqlloader features

2004-03-12 Thread azwa
Hi ,    does postgresql support for the sql loader functionality like oracle does ??? if no, is there any tools specific to do this task connect to postgresql database??? i'm looking into open-source tools that can do import & export facility. thanks in advance