[SQL] Values like ''

locais_sala.nr_sala ORDER BY   cronograma_evento.nr_sala,   cronograma_evento.tm_hora_inicial;           >\\\!/<   55 11 5080 9258    !_"""_!   Elielson Fontanezi    (O) (o)  

[SQL] ALTER TABLE ... DROP CONSTRAINT

Hi all!       Who can tell me what postgres version supports ALTER TABLE... DROP CONSTRAINT without the need of droping the table to remove a simple coinstraint. (link)    >\\\!/< 55 11 5080 9283   !_""

[SQL] RES: [GENERAL] ERROR: DefineIndex: index function must be marked iscachable

Direct blocks: 0 read, 0 written --- -Mensagem original- De: Stephan Szabo [mailto:[EMAIL PROTECTED] Enviada em: sexta-feira, 25 de julho de 2003 16:47 Para: Elielson Fontanezi Cc: pgsql-general; pgsql-sql Assunto: Re: [GENERAL] ERROR: DefineIndex: index

[SQL] ERROR: DefineIndex: index function must be marked iscachable

BEGIN  return TRUNC(v_nr_proponente/10,0)*10   END;' LANGUAGE 'plpgsql';    >\\\!/< 55 11 5080 9283       !_"""_! Elielson Fontanezi   (O) (o)

RES: [GENERAL] [SQL] ERROR: DefineIndex: index function must be marked iscachable

Oh sorry! Linux netlab142.prodam 2.4.8-26mdk #1 Sun Sep 23 17:06:39 CEST 2001 i686 unknown pg_ctl (PostgreSQL) 7.2.1 -Mensagem original- De: Stephan Szabo [mailto:[EMAIL PROTECTED] Enviada em: sexta-feira, 25 de julho de 2003 16:25 Para: Elielson Fontanezi Cc: pgsql

[SQL] ERROR: DefineIndex: index function must be marked iscachable

must be marked iscachablepostgres$        >\\\!/< 55 11 5080 9283   !_"""_!     Elielson Fontanezi   (O) (o) PRODAM - Technical Support Analyst--

[SQL] Query analyse

Good morning!       First of all, my envoronment is:     Linux netlab142.prodam 2.4.8-26mdk #1 Sun Sep 23 17:06:39 CEST 2001 i686 unknown    pg_ctl (PostgreSQL) 7.2.1       I would like some suggestions on how to speed up a query.       Both of the queries below are identical exce

[SQL] 3-tier

e awaited a question. Elielson Fontanezi DBA Technical Support - PRODAM Parque do Ibirapuera s/n - SP - BRAZIL +55 11 5080 9493 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[SQL] formating numeric values

A Question... Since before your sun burned hot in space and before your race was born, I have awaited a question. Elielson Fontanezi DBA Technical Support - PRODAM Parque do Ibirapuera s/n - SP - BRAZIL +55 11 5080 9493 ---(end of broadcast)-

RES: [SQL] RES: [GENERAL] set DateStyle to 'SQL'

Bom dia Roberto! I have just read these documents. The variables listed in the link below, say about variable that I cannot set from a .profile file. By the way, if I wat to state that all NUMERIC values must follow a format as ###,###.##& these docs do not say how to do t

[SQL] RES: [GENERAL] The best book

E.F.:> E.F.:> Hi, E.F.:> E.F.:> Well depends what are you looking for. E.F.:> E.F.:> I am using a lot PostgreSQL: Introduction and Concepts E.F.:> by Bruce Momjian. E.F.:> Then I have bought "PHP and PostgreSQL Advanced Web E.F.:> Programming" by E.F.:> Ewald Geschwinde and Hans-Juergen Sc

[SQL] RES: [GENERAL] The best book

Thanks to answer me. You was very kindly to write me a so nice text. :-) E.F.:> The "best book" for you really depends on what you are after! E.F.:> E.F.:> Are you interested in a book which is easy to read, gives good E.F.:> foundational concepts, and gives you decent skills with E.F.:> Postgr

[SQL] Numeric Style format

A Question... Since before your sun burned hot in space and before your race was born, I have awaited a question. Elielson Fontanezi DBA Technical Support - PRODAM +55 11 5080 9493 ---(end of broadcast)--- TIP 3: if posting/reading through Us

[SQL] set DateStyle to 'SQL'

I do that? .. A Question... Since before your sun burned hot in space and before your race was born, I have awaited a question. Elielson Fontanezi DBA Technical Support - PRODAM +55 11 5080 9493 ---(end of broadcast)--- TIP 1: sub

[SQL] RES: [GENERAL] set DateStyle to 'SQL'

E.F.:> De: Elielson Fontanezi [mailto:[EMAIL PROTECTED]] E.F.:> Enviada em: sexta-feira, 26 de julho de 2002 10:28 E.F.:> Para: pgsql-general E.F.:> Cc: pgsql-sql E.F.:> Assunto: [GENERAL] set DateStyle to 'SQL' E.F.:> E.F.:> E.F.:> Hi folks! E.F.:> E

RES: RES: [SQL] Queries not using Index

24 de julho de 2002 12:46 > Para: Elielson Fontanezi > Cc: pgsql-sql; pgsql-general > Assunto: Re: RES: [SQL] Queries not using Index > > > Hi! > > Thanks for the help. Please see my responses below. > > On Wed, 24 Jul 2002, Elielson Fontanezi wrote: > >

RES: [SQL] Queries not using Index

Hi! What kind of index is t2002_06_station_idx? Have you done this SELECT command below, right? select * from t2002_06 WHERE station = 'SAMI4'; This SELECT causes a sequention scan 'cause your index is not HASH type, but likely a BTREE one. BTREE index is

[SQL] Editor for pgsql

Hello Folks! Maybe every DBA knows that there is a good shareware to editing Oracle PL/SQL programs named PL/SQL Developer. I'd like to know if someone knows something near to this software for Postgres pgSQL. Thanks! Elielson, ---(end