Re: [SQL] Help me

2003-09-04 Thread George Weaver
Hi Yaroslav,   You must set the language as:     LANGUAGE 'plpgsql';   Regards, George - Original Message - From: Yaroslav Ulyanov To: [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 2:46 AM Subject: [SQL] Help me Hello   I cannot write new functio

[SQL] Help me

2003-09-04 Thread Yaroslav Ulyanov
Hello   I cannot write new function with local variables (see image in attachment).   That I do wrong?     Best regards,Yaroslav Ulyanov[EMAIL PROTECTED] <> ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [SQL] running aggregates

2003-09-04 Thread Tomasz Myrta
f1sum_f1 avg_f1 pseudo_recno 10 10 10 1 20 30 15 2 30 60 20 3 40 100 25 4 50 150 30 5 60 210 35 6 I know I can do this by iterating with a plpgsql routine, but there must be a means simply using SQL select

Re: [SQL] MINUS & ROWNUM in PostGres

2003-09-04 Thread Rod Taylor
> 1)Do we have a replacement in PostGres for MINUS operator of Oracle . I believe MINUS is non-standard word for EXCEPT, correct? > 2 Also I need to find an alternative for ROWNUM in oracle.. If you are looking for a unique identifier, try using the OID. signature.asc Descript

[SQL] MINUS & ROWNUM in PostGres

2003-09-04 Thread Jomon Skariah
Hi, We are in the process of migrating of our application from Oracle to PostGreSQL. we are facing a few problems with PL/SQL Code.. 1) Do we have a replacement in PostGres for MINUS operator of Oracle . 2 Also I need to find an alternative for ROWNUM in oracle.. Can anyo

[SQL] running aggregates

2003-09-04 Thread Glenn
f1sum_f1 avg_f1 pseudo_recno 10 10 10 1 20 30 15 2 30 60 20 3 40 100 25 4 50 150 30 5 60 210 35 6 I know I can do this by iterating with a plpgsql routine, but there must be a means simply using SQL Thank

[SQL] Change column data type

2003-09-04 Thread Senthil Kumar S
Dear Friends,   Using Postgres 7.3.4 over the linux server 7.3.   Is it possible to alter/change the data type of a existing table's column, with out dropping and recreating a column of same name.   Thanks for ur knowledge sharing.     Regards Kumar  

Re: [SQL] Fw: Change column data type

2003-09-04 Thread scott.marlowe
On Tue, 2 Sep 2003, Kumar wrote: > > Dear Friends, > > Using Postgres 7.3.4 over the linux server 7.3. > > Is it possible to alter/change the data type of a existing table's > column, with out dropping and recreating a column of same name. Only for certain types, and only by hacking the syst

[SQL] pg_type and type names

2003-09-04 Thread sad
hello developers, another question i have to ask: may the type names changes in the future releases? may the type oids changes...? I need look-up system catalog for a type of a field, so i need a constancy of some kind :-) ---(end of broadcast)--