Re: [GENERAL] psql proxy

2008-05-16 Thread Gerald Quimpo
On Friday 16 May 2008 23:34:56 Linsong GUO wrote: > in the terminal I input psql -h localhost -U bob network > > the problem is I do not know how to capture the user name and password > information in my proxy code. > > after read function it is seems nothing in the buf > > could you suggest some s

Re: [GENERAL] Affected # of Rows After TRIGGER/RULE Return

2008-05-14 Thread Gerald Quimpo
On Wednesday 14 May 2008 19:10:18 Volkan YAZICI wrote: > On Wed, 14 May 2008, Gerald Quimpo <[EMAIL PROTECTED]> writes: > > Instead of trying to update the row in place, insert the row again, > > but with the field you need to mangle (in your example, "plate", > &

Re: [GENERAL] Affected # of Rows After TRIGGER/RULE Return

2008-05-13 Thread Gerald Quimpo
On Wednesday 14 May 2008 02:59:27 Volkan YAZICI wrote: > RETURN NULL; > queries return 0 as # of affacted rows. > And this causes JDBC > applications (specifically Hibernate) ROLLBACK query as some failure > occured. At least, shouldn't the latter one return 1 as # of affected > rows? Any

Re: [GENERAL] Extract only numbers from a varchar column

2008-05-10 Thread Gerald Quimpo
On Tuesday 06 May 2008 07:09:56 Leandro Casadei wrote: > I need to extract only the first occurence of numbers from a column that > is varchar. > abc200xx -> 200 > 340ppsdd -> 340 > 150ytyty555 -> 150 tiger=> select substring('abc200xx300ff','[0-9]+'); substring --- 200 (1 row) Time: