[SQL] Create Trigger porting problem from Oracle to PostgreSQL7.3.2

2003-12-03 Thread Doris Bernloehr
Hello I've got a problem in porting a trigger from Oracle into PostgreSQL. In Oracle you can choose between UPDATE and UPDATE OF COLUMN ... Is there a way to have the same functionality in PostgreSQL? Hope anyone can give me an advice. Doris ---(end of broadcast)---

Re: [SQL] Regarding decode function

2003-10-03 Thread Doris Bernloehr
Right now I have a query which uses decode function to get data in Oracle database, I want know is there any alternative function to decode which can do the decode functionality in Postgresql. Oracle: decode (value, 0, 'zero', 1, 'one', 'unknown') In PostgreSQL you have to use CASE WHEN Syntax:

[SQL] SQL Syntax problem

2003-09-29 Thread Doris Bernloehr
Hello. I've got a problem in porting the following select statement from Oracle to Postgres, because of the characters after "b.bet_id" and "f.ask_id" in the where clause: (+) I don't know what these characters mean and how I can transform these into PostgreSql Syntax. select... from