Re: [SQL] LEFT OUTER JOIN issue

--- On Wed, 4/21/10, Thomas BOURIMECH wrote: From: Thomas BOURIMECH Subject: [SQL] LEFT OUTER JOIN issue To: "'pgsql-sql@postgresql.org'" Date: Wednesday, April 21, 2010, 9:06 AM Hi  everyone, here is my problem :   I got two tables :   CREATE TABLE "public"."calendar_t

Re: [SQL] Pulling additional columns with aggregate

--- On Thu, 10/8/09, sub3 wrote: From: sub3 Subject: [SQL] Pulling additional columns with aggregate To: pgsql-sql@postgresql.org Date: Thursday, October 8, 2009, 1:14 PM Hi, I have 2 tables.  I want to be able to calculate the closest value in one (tempvalues), to the closest value in the ot

Re: [SQL] Permanent alias for postgresql table

-- On Thu, 3/12/09, Marco Lechner wrote: > From: Marco Lechner > Subject: Re: [SQL] Permanent alias for postgresql table > To: pgsql-sql@postgresql.org > Date: Thursday, March 12, 2009, 2:26 PM > Hi Mina, > > thanks for your answer. I thought about that, but don't > views decrease performance

Re: [SQL] wired behaviour

--- On Fri, 11/28/08, Lutz Steinborn <[EMAIL PROTECTED]> wrote: > From: Lutz Steinborn <[EMAIL PROTECTED]> > Subject: [SQL] wired behaviour > To: pgsql-sql@postgresql.org > Date: Friday, November 28, 2008, 1:51 PM > Hello, > > I have an problem understanding a simple query: > > For example I

Re: [SQL] Problem with pg_connect() in PHP

--- On Fri, 9/26/08, Edward W. Rouse <[EMAIL PROTECTED]> wrote: > From: Edward W. Rouse <[EMAIL PROTECTED]> > Subject: Re: [SQL] Problem with pg_connect() in PHP > To: "'pgsql-sql'" > Date: Friday, September 26, 2008, 5:23 PM > Can I assume the missing ‘.”’ From the end of > PG_PASSWORD is a c

Re: [SQL] PL/pgSQL function syntax question?

--- On Mon, 9/8/08, Ruben Gouveia <[EMAIL PROTECTED]> wrote: > From: Ruben Gouveia <[EMAIL PROTECTED]> > Subject: [SQL] PL/pgSQL function syntax question? > To: "pgsql-sql" > Date: Monday, September 8, 2008, 9:40 PM > i get the following error when i try and create the > following function: >

Re: [SQL] Correct Insert SQL syntax?

--- On Thu, 9/4/08, Ruben Gouveia <[EMAIL PROTECTED]> wrote: > From: Ruben Gouveia <[EMAIL PROTECTED]> > Subject: [SQL] Correct Insert SQL syntax? > To: "pgsql-sql" > Date: Thursday, September 4, 2008, 10:16 PM > Will this syntax work: > > fcn_stats are all in the same schema > > CREATE OR R

Re: [SQL] Concat field result in select query

> Hi all, > > I was wondering if there is a way to concatenate the > results of a field in a > select to return it as a single string. > > Example : > > my_field > -- > 1 > 2 > 3 > > select concat_something(my_field) from my_table group by > something; > the result expected would be

Re: [SQL] Join question

--- On Tue, 8/19/08, Edward W. Rouse <[EMAIL PROTECTED]> wrote: > From: Edward W. Rouse <[EMAIL PROTECTED]> > Subject: Re: [SQL] Join question > To: "'Daniel Hernandez'" <[EMAIL PROTECTED]>, pgsql-sql@postgresql.org > Date: Tuesday, August 19, 2008, 1:35 PM > I have tried left, right outer and

Re: [SQL] Encrytion in postgres field in table

use md5 function in a trigger when insert data or see this link http://www.postgresql.org/docs/8.3/static/pgcrypto.html --- On Mon, 7/28/08, Chris Preston <[EMAIL PROTECTED]> wrote: > From: Chris Preston <[EMAIL PROTECTED]> > Subject: [SQL] Encrytion in postgres field in table > To: pgsql-sql@

Re: [SQL] truncate vs. delete

The truncate is more fast to delete, the truncate command not scan the table http://www.postgresql.org/docs/8.3/static/sql-truncate.html --- On Thu, 7/24/08, A. Kretschmer <[EMAIL PROTECTED]> wrote: > From: A. Kretschmer <[EMAIL PROTECTED]> > Subject: Re: [SQL] truncate vs. delete > To: pgsql-s

Re: [SQL] How to GROUP results BY month

i think this work select id,count from table group by to_char(date,'MM') --- On Wed, 7/16/08, A. Kretschmer <[EMAIL PROTECTED]> wrote: > From: A. Kretschmer <[EMAIL PROTECTED]> > Subject: Re: [SQL] How to GROUP results BY month > To: pgsql-sql@postgresql.org > Date: Wednesday, July 16, 2008, 5:

Re: [SQL] i can't connect after some periode

--- On Thu, 7/10/08, aldy <[EMAIL PROTECTED]> wrote: > From: aldy <[EMAIL PROTECTED]> > Subject: Re: [SQL] i can't connect after some periode > To: pgsql-sql@postgresql.org > Date: Thursday, July 10, 2008, 8:16 AM > From: "A. Kretschmer" > <[EMAIL PROTECTED]> > Sent: Thursday, July 10, 2008 14:

Re: [SQL] i can't connect after some periode

what is the message error? i have a similar problem whit a software, this software not closed the connection to the server and not reuse the previously open. --- On Thu, 7/10/08, aldy <[EMAIL PROTECTED]> wrote: > From: aldy <[EMAIL PROTECTED]> > Subject: [SQL] i can't connect after some peri

Re: [SQL] exclude part of result

select * from ( SELECT DISTINCT a, b, c, now(), count(item_pk) FROM product LEFT JOIN item ON item.product_fk = product_pk WHERE ... GROUP BY a, b, c ) t1 where not exists (select a,b,c, from navigation t2 where t2.a = t1.a and t2.b = t1.b and t2.c = t1.c) --- On Thu, 6/26/08, Tarlika Elisabeth