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
h
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,
academico.aca_t_alumnocurso.cic_
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
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))
Hi,
how do I change the encoding type in postgreSQL (8) from UTF-8 to ISO-8859-1?
many thanks
Andrew
<>
+The home of urban music
+ http://www.beyarecords.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
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 t
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 table:
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 Deploy
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?
