[SQL] Debug (is it PostgreSQL?)

My Linux is reporting the following message: DEBUG: Connection stats: total - 1, free - 0, deleted - 0 DEBUG: Checking for jobs to run DEBUG: Sleeping... DEBUG: Clearing inactive connections DEBUG: Connection stats: total - 1, free - 0, deleted - 0 DEBUG: Checking for jobs to run DEBUG: Sleeping

Re: [SQL] can someone explain confusing array indexing nomenclature

I am quite sure the [2] is not discarded, easy enough to test but I don't have access to PG at the moment. Achilleas Mantzios wrote: > > Στις Πέμπτη 15 Φεβρουάριος 2007 18:55, ο/η chrisj έγραψε: >> Thanks Achilleas, >> >> I see what you are saying, but if we consider just the index "[2]" for a

Re: [SQL] There is a different cast than ::MyOtherType() ?

am Fri, dem 16.02.2007, um 9:30:14 -0300 mailte Ezequias Rodrigues da Rocha folgendes: > Hi list, > > My Delphi app does not suport this kind of cast: > > Select id, desc::Varchar(50) from myTable This is PG-only-style, the spec is: select id, cast(desc as varchar(50)) from mytable; But i'

Re: [SQL] There is a different cast than ::MyOtherType() ?

Ezequias Rodrigues da Rocha escribió: > Hi list, > > My Delphi app does not suport this kind of cast: > > Select id, desc::Varchar(50) from myTable Try select id, cast(desc as varchar(50)) from yourTable -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL

Re: [SQL] can someone explain confusing array indexing nomenclature

Στις Πέμπτη 15 Φεβρουάριος 2007 18:55, ο/η chrisj έγραψε: > Thanks Achilleas, > > I see what you are saying, but if we consider just the index "[2]" for a > moment, > it means something different depending upon the context (in one case it > means "2" and in the other case it means "1:2") and the c

Re: [SQL] Retrieving 'Credit' when 'C'

Perfect, I learn this lesson now. This case is quite good. My Best Regards Ezequias 2007/2/15, Phillip Smith <[EMAIL PROTECTED]>: SELECT when, CASE WHEN type = 'C' THEN 'Credit' END AS type FROMmytable; Assuming your column names are actually "when" and "type" you should ju

[SQL] There is a different cast than ::MyOtherType() ?

Hi list, My Delphi app does not suport this kind of cast: Select id, desc::Varchar(50) from myTable I don't know if it is a odbc problem or a Delphi problem (or a BDE problem). *Even though I would like to try another cast. Does anyone is avaliable to help me ? *-- =-=-=-=-=-=-=-=-=-=-=-=-=-=