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
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
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
> 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
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
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
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
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
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)--