Yes, but after creating some function, we can get sql error messages. But I
not comfortable that much in that.
For Procedures and Packages we can use Functions
Any other option in pl/PGSQL
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED
1. How to migrate Procedures and Packages from Oracle to PostgreSQL
2. How to find error messages in PostgreSQL thrown from an Exception (as we
can get messages in Oracle with "SQLERRM" keyword)
for example --
--Raise an exception
RAISE EXCEPTION 'No Data found for record id % ' ,recordid
Hi there, Has anyone migrated
Oracle database to PostgreSQL? If yes, could you please help me
-
1.
How to migrate Procedures and Packages
from Oracle to PostgreSQL
2.
How to find error messages in PostgreSQL thrown from an Exception (as we can get
messages in Oracle with "SQLE
Hi.
Is there a way to make a serial columm that works with father table???
I.e:
I have created a table called "vending" and its chield table called "items".
The items table have a serial columm, but I need the serial colum starts with 0
for each vending.
create table vending (
id serial prima
Ragnar Hafstað (gnari) writes:
> On Mon, 2005-04-04 at 10:47 +, Ragnar Hafstað wrote:
> > On Mon, 2005-04-04 at 12:16 +0200, Michael L. Hostbaek wrote:
> > > [problem]
> > [slightly broken solution]
>
> I forgot a FROM clause, and you might want to add a
> ORDER BY clause, if that is important
On Mon, 2005-04-04 at 10:47 +, Ragnar Hafstað wrote:
> On Mon, 2005-04-04 at 12:16 +0200, Michael L. Hostbaek wrote:
> > [problem]
> [slightly broken solution]
I forgot a FROM clause, and you might want to add a
ORDER BY clause, if that is important:
select part,mfg,
sum(CASE WHEN eta
On Mon, 2005-04-04 at 12:16 +0200, Michael L. Hostbaek wrote:
> I've got a problem selecting some specific data from my table. Imagine
> the following rows:
>
> part | mfg | qty | price | eta
> ---
> TEST1 ABC 10 100(No ETA, as item
Michael L. Hostbaek wrote:
I've got a problem selecting some specific data from my table. Imagine
the following rows:
part| mfg | qty | price | eta
---
TEST1ABC 10 100(No ETA, as item is in stock)
TEST1ABC 12 120
I've got a problem selecting some specific data from my table. Imagine
the following rows:
part| mfg | qty | price | eta
---
TEST1ABC 10 100(No ETA, as item is in stock)
TEST1ABC 12 120 04/04
TEST2CBA
