Re: [SQL] Differences between bit string constant sintax

2009-09-10 Thread Jasen Betts
On 2009-09-09, Oliveiros C, oliveiros.crist...@marktest.pt wrote: This is a multi-part message in MIME format. --=_NextPart_000_013B_01CA3146.85B62920 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Dear All, I have a table which has a

[SQL] Trapping 'invalid input syntax for integer'

2009-09-10 Thread Mario Splivalo
Is there a way to trap this error in plpgsql code? I have a function that accepts integer and character varying. Inside that function I need to cast that varchar to integer. Of course, sometimes that is not possible. When I run function like that, I get this errror: fidel=# select * from

Re: [SQL] Trapping 'invalid input syntax for integer'

2009-09-10 Thread Marcin Krawczyk
Hi, I believe you're looking for invalid_text_representation. EXCEPTION WHEN invalid_text_representation THEN regards mk 2009/9/10 Mario Splivalo mario.spliv...@megafon.hr Is there a way to trap this error in plpgsql code? I have a function that accepts integer and character varying.

Re: [SQL] Trapping 'invalid input syntax for integer'

2009-09-10 Thread Mario Splivalo
Marcin Krawczyk wrote: Hi, I believe you're looking for invalid_text_representation. EXCEPTION WHEN invalid_text_representation THEN Thnx, that is it. Mike -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription:

Re: [SQL] how to: refer to select list calculations other places in the calculations.

2009-09-10 Thread Rob Sargent
I might do the substitution, analyse the query and hope to break it up. Can it possibly be optimal? Little, Douglas wrote: Hi Rob, Thanks for the response. Repeating the base calculation will work but the calculations are stunningly complex and long. Repeating them will undoubtly increase

[SQL] Encryption in the tables of a Postgres 7.3.2 database

2009-09-10 Thread jtayamai
Hi, I've a Postgres DB release 7.3.2 and some developed C++ and PHP code so as to communicate with it. Currently, the data I've in the different tables is stored with no encription at all, and I was wondering if there would be an easy way to get it encrypted without major changes in the already

[SQL] Talend : Talend Integration Suite vs Talend Open Studio

2009-09-10 Thread Rstat
Hi all, I have been working with Talend Open Studio for a few weeks now and would like to have your opinion. Is using Talend Integration Suite really better compared to using Talend Open Studio? On what kind of project can you not use Talend Open Studio and would be best to use Talend