Bryan Field-Elliot wrote:
Searching the archives,
it seems you once tried to find out how to "drop constraint trigger" on
PostgreSQL; did you ever figure it out? Thank
you,Bryan
I wrote the following function and installed it in my database.
I can then call it with a select (yuk) to drop a co
> Hi,
>
> I'am wondering if it is possible to retrieve the last added
> record of a table?
> I don't think there is a default SQl-query to do so. Is there
> a PostgreSQL way?
What is it you want to do? If you want to find out what auto-
generated ID will be or was inserted, you can use a sequenc
Hi,
I'am wondering if it is possible to retrieve the
last added
record of a table?
I don't think there is a default SQl-query to do
so. Is there
a PostgreSQL way?
gr,
Willem
>
Hi, there,
Is there any way to handle exception ( such as cannot insert duplicate key on
a unique index) in
plpgsql function?
I don't want it abort whole transaction instead I want to do something else if
it happened,
but I don't want to use a select stmt first to waste the time.
In Orcale,
There was a bug (which should be fixed for 7.1) that got the
arguments wrong for the alter time check of the existing data.
I think I should be able to get a patch together to fix it once
I get a copy of the 7.0.3 source.
Can you send the table schema as well so I can test it out?
Stephan Szab
Hi,
The syntax you used works fine for me.
francis=# select version();
version
---
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2
(1 row)
Hope this helps
Francis Solomon
> -Original Mes
hello, list.
are subqueries alloved as values in an update command ?
e.g.
update a set a.attribute1 = a.attribute1 +
(select sum(b.attribute1) from b where b.attribute2=a.attribute2);
If yes, how is the correct syntax ?
If not, is there a hope for it in a future version ?
