Re: [SQL] PERSISTANT PREPARE (another point of view)

1. like the idea because right now I'm having to track which prepared statement (sets) are in which session. using xcache to track this, but little bit dangerous. could query the database first but the whole idea is to take a load off the db. 2. perhaps "global" could mean simply that the def

Re: [SQL] PERSISTANT PREPARE (another point of view)

> > 2. perhaps "global" could mean simply that > the definition is global - if called for session and not > exist in session, then session prepares it first from the > global def. there would need to be a back reference in > case the global def was changed or dropped. > > > > Yes, this seems to

[SQL] uso de dblink en php

hola a todos estoy programando en php tengo el siguiente esquema de BD BDACADEMICA personas(idpersona, nombres, paterno) BDSIAP PersonasDatosActualizables(idpersona, direccion, telefono) son dos bases de datos, de las cuales mediante una sola consulta quiero unir los datos de l

[SQL]

hola a todos estoy programando en php tengo el siguiente esquema de BD BDACADEMICA personas(idpersona, nombres, paterno) BDSIAP PersonasDatosActualizables(idpersona, direccion, telefono) son dos bases de datos, de las cuales mediante una sola consulta quiero unir los datos de l

[SQL] do unneeded outer joins cost?

for example: selectt1.* from t1 left join t2 on( ); since t2 is not used in the result nor is it used in determining the result, is the to left join t2 used? (the question goes as to how much generated sql needs to be cleaned to be efficient) -- Sent via pgsql-sql maili

[SQL] Outputting the Tables of a database

Hello all, I am trying to out put the tables of a database. I have psql -d mydb -c "\d" This works but I am looking at turning on the html out put which it will not do. If I am able to get just the table titles that would be most ideal.

[SQL] Outputting the Tables of a database

Hello all, What would the query line be to mimic mydb=>\d tablename ? I have been able to run a query to mimic #psql -l and to mimic mydb=>\d thanks for the help Brian

[SQL] Problem with coalesce..

Hello,       Was wondering if such a call is unsupported, or a bug?   7.0.2 (postgresql, linux redhat 7.0)   SELECT COALESCE ((SELECT NULL,1)   returns a 1, correct..   however..   SELECT COALESCE ((SELECT CURVALUE FROM TABLEKEYS WHERE TABLENAME = 'BUYER'),1)   returns a "UNKNOWN expression t

Re: [SQL] Transpose rows to columns

El Lun 12 Ene 2004 22:12, David Witham escribió: >DW: Hi, >DW: >DW: I have a query that returns data like this: >DW: >DW: cust_idcust_name month costrevenue margin >DW: 991234 ABC 2003-07-01 10 15 5 >DW: 991234

Re: [SQL] Transpose rows to columns

El Lun 12 Ene 2004 22:12, David Witham escribió: >DW: Hi, >DW: >DW: I have a query that returns data like this: >DW: >DW: cust_idcust_name month costrevenue margin >DW: 991234 ABC 2003-07-01 10 15 5 >DW: 991234

<    1   2   3