[GENERAL] pl/pgsql for loops

Hello I have some for x in select ... loops which compares current record with previous ones. Is it possible to check if such loop is reaching final pass? Now, I check found variable after the loop and usually duplicate part of it's code. -- Regards, Tomasz Myrta -- Sent via pgsql

Re: [GENERAL] How can I tell, in a trigger, if a value in a string is an integer.

Philip W. Dalrymple napisal 29.10.2008 15:26: set_config('session.sessionid','23',false); I validate strings with regexp. This expression returns true: select '23' ~'^-{0,1}[0-9]+$'; If it's true - you can cast it safely: select cast('23' as integer) -- Regards, Tomasz Myrta -- Sent via

Re: [GENERAL] Query m:n-Combination

join_table where mn_2_c_id in (1,2,3,4) group by mn_2_r_id having count(*)=4 (4 = how many communities we should find) -- Regards, Tomasz Myrta -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How with to emulate function TRANSFORM from Access in Postgress?

/tablefunc.html -- Regards, Tomasz Myrta -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Order by with spaces and other characters

is initialized with C locale. -- Regards, Tomasz Myrta -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to get user list and privileges?

. -- Regards, Tomasz Myrta -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PQescapestringConn not found in libpq.dll

with the information that the ordinal 126 was not found in the dynamic library libpq.dll It sounds like what you're actually using is an 8.1 or older libpq.dll. My 8.1.5 libpq.dll contains this function. -- Regards, Tomasz Myrta -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] PQescapestringConn not found in libpq.dll

. Use |PQescapeStringConn instead. -- Regards, Tomasz Myrta | -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ssl woes after 8.1 - 8.3 update

trial and errors? This one should be enough: http://www.postgresql.org/docs/current/interactive/ssl-tcp.html You should either provide matching client certificate or remove root.crt from server configuration. -- Regards, Tomasz Myrta -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] know the schema name in a trigger

.. Did you try function current_schema() ? -- Regards, Tomasz Myrta ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Linux distro

long for newest versions - even beta and rc. Regards, Tomasz Myrta ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] SQL query question

from parent where not exists (select * from child where child.iod_parent=parent.oid); Regards, Tomasz Myrta ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] pl/pgsql oddity

then return '' 38''; bleblbebleblebe sfdsdf; nothing special; else return ''this is not possible''; end if; end;' language 'plpgsql'; select fubar(); Regards, Tomasz Myrta ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please