Re: [GENERAL] function return value inside a trigger function

2012-10-07 Thread joao tiago a. m. viegas
sorry for the late update thank you all, I found the cause, that specific sentence was correct, it was in another sentence of the same function, I think it was late at night and I was tired. thank you anyway best regards jtv On 27 September 2012 02:26, Tom Lane wrote: > joao viegas writes:

[GENERAL] long names get truncated

2011-07-08 Thread A . M .
Hello, I was bitten by a length-truncated role name used in a script since the truncation only raises a NOTICE. The symptom was that the some GRANTs ended up on the wrong objects after name truncation. Then, I experimented with tables with long names and was surprised by the truncation behavio

Re: [GENERAL] convert access sql to postgresql

2007-11-16 Thread A . M .
On Nov 16, 2007, at 5:43 PM, Tom Hart wrote: Tom Hart wrote: Peter Eisentraut wrote: Tom Hart wrote: Specifically I'm looking at these two lines isactive and (mb_mail_cd=0 or mb_mail_cd=1) as ismail, ismail and (mb_stat_cd=0 or mb_stat_cd=2) as ispromomail, which appear to use other field

Re: [GENERAL] cursors in postgres

2007-03-29 Thread A . M .
On Mar 29, 2007, at 10:47 , Jasbinder Singh Bali wrote: Hi, I've written a function using cursors as follows: can anyone please comment on the text in red. -- CREATE OR REPLACE FUNCTION sp_insert_tbl_email_address(int4, text, text, text)