[GENERAL] postgres cascade weird behaviour

Hi I have table A with pk that is being referenced by 5 other tables as foreign key I have put all those tables reference to be ON DELETE CASCADE However for some reason when I tried to delete one of the row in table A, out of 5 tables, 1 of them didn't actually get deleted but the transaction is

[GENERAL] ask: select right(column) ???

ostgresql or am I wrong? since I look at SQL Key Words table and it's written as reserved Thank you Regards Hendra

[GENERAL] display array field as row

you know any sql syntax that would do? I cannot find it in documentation or is it not possible? Regards Hendra

[GENERAL] sql syntax to replace desc

ntax to do that? I'm not talking about \d option at psql console since I need that data to be called from programming language such as PHP and Ruby Thank you Regards Hendra

Re: [GENERAL] select return case sensitive record

Sorry, forgot to add subject On 12/5/08, hendra kusuma <[EMAIL PROTECTED]> wrote: > Dear all, > > I create a stored function to select some row and return it as cursor. > the function receive some parameter that later I put it in where clause > But I found that selec

[GENERAL]

Dear all, I create a stored function to select some row and return it as cursor. the function receive some parameter that later I put it in where clause But I found that select statement runs Case Sensitive so if I have a record, for example - id -nama_pelanggan - 1 - Wira I wil get the r

[GENERAL] Serial - last value

hey get the last_value they should really get or is there another way to code that can ensure they really get the right value Thank you Regards Hendra

[GENERAL] exception

on we would like to catch? something like ELSE or what :) Regards Hendra -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Stored function - send array as parameter to stored function

them are working how is it really to call this function Thank you Hendra -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Array as parameter for stored procedure

ven't try this yet, since I lack of knowledge to finish this code Can anyone help me? Or is there a better solution for this case? Thank you Regards, Hendra

[GENERAL] Hi there, new here and have question

ect * into resultset from employee where id_dept = id_dept; return resultset; end $$ language 'plpgsql'; I believe you get what I want But I just couldn't finish the code since I miss something I manage to find 'setof' but have no idea on how to use it Any suggestion everyone? Thank you, Regards, Hendra