[SQL] User defined types

Hello: I have a user define type called VALID_TIME. It is declared as follows: CREATE TYPE VALID_TIME AS (t_s TIMESTAMP, t_e TIMESTAMP); Once I have used this in a table declaration, is it possible to extract parts of it, for example to only read t_s or t_e? If so, how do I do this?

Re: [SQL] NULLS and string concatenation

There is an easy solution anyway, use coalesce to ensure you are never returning a null result for any components of the concat. e.g. select 'some text, blah:' || coalesce(NULL, '') equates to 'some text, blah:' || '' hence 'some text, blah:' Terry Fielder Manager Software Development and

[SQL] PG7.4.5: query not using index on date column

Hi Folks, I was hoping someone could help me to improve the performance of a query I've got that insists on doing a seq. scan on a large table. I'm trying to do some reporting based on my spam logs which I've partly digested and stored in a table. Here are the particulars: The messages

Re: [SQL] User defined types

Reza Shanbehbazari Mirzaei [EMAIL PROTECTED] writes: I have a user define type called VALID_TIME. It is declared as follows: CREATE TYPE VALID_TIME AS (t_s TIMESTAMP, t_e TIMESTAMP); Once I have used this in a table declaration, is it possible to extract parts of it, for example to

[SQL] HowTo change encoding type....

x-tad-biggerHi, how do I change the encoding type in postgreSQL (8) from UTF-8 to ISO-8859-1? many thanks Andrew/x-tad-bigger inline: beya-email.gif  +The home of urban music + http://www.beyarecords.com ---(end of broadcast)--- TIP 8: explain

Re: [SQL] PG7.4.5: query not using index on date column

Dave Steinberg [EMAIL PROTECTED] writes: - Seq Scan on messages (cost=0.00..21573.04 rows=436426 width=54) (actual time=5.523..6304.657 rows=462931 loops=1) Filter: ((received_date = '2004-11-01'::date) AND (received_date = '2004-11-30'::date)) How many

[SQL] Type Inheritance

Does anyone know how to implement type inheritance in postgresql? in oracle you just use the word UNDER in ur code i.e: CREATE TYPE test2_UDT UNDER test1_UDT AS (abc INT); any ideas? -- __ Check out the latest SMS services @ http://www.linuxmail.org

[SQL] select with a function

Hi all, i need some help i wanna do a select with a function call like this: SELECT academico.aca_f_siguientecurso( academico.aca_t_alumnocurso.ent_codigo, academico.aca_t_alumnocurso.sec_codigo, academico.aca_t_alumnocurso.ani_codigo,

Re: [SQL] HowTo change encoding type....

Andrew M wrote: how do I change the encoding type in postgreSQL (8) from UTF-8 to ISO-8859-1? Dump your database, drop your database, recreate your database with the different encoding, reload your data. Make sure the client encoding is set correctly during all this. -- Peter Eisentraut