Re: [SQL] Converting between UUID and VARCHAR

2008-11-28 Thread Helio Campos Mello de Andrade
"public.t1" > Column | Type | Modifiers > +--+--- > u1 | uuid | > > > > Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) > GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http:/

[SQL] Invitation to connect on LinkedIn

2008-11-12 Thread Helio Campos Mello de Andrade
LinkedIn sql, I'd like to add you to my professional network on LinkedIn. - Helio Learn more: https://www.linkedin.com/e/isd/404530268/6Oj19fqk/ -- What is LinkedIn and why should you join? http://learn.linkedin.com/what-is-linkedin/

Re: [SQL] Query optimizing

2008-11-10 Thread Helio Campos Mello de Andrade
s returned by it to only 1 result. Regards -- Helio Campos Mello de Andrade On Mon, Nov 10, 2008 at 8:43 AM, Sebastian Ritter < [EMAIL PROTECTED]> wrote: > Hi all, > > I was hoping to receive some advise on a slow running query in our > business' Issue Tracking System

Re: [SQL] Seq scan on join, not on subselect? analyze this

2008-11-10 Thread Helio Campos Mello de Andrade
;< "n". 2ยบ It uses "k-results" and look for the for the rows where "word_key" is in the group created by the INNER Query. That's why you have the difference between the query's "Total runtime". Regards -- Helio Campos Mello de Andrade

Re: [SQL] Subqueries

2008-10-30 Thread Helio Campos Mello de Andrade
and p.groupe = v.groupe > > > > *ERROR: invalid reference to FROM-clause entry for table "v"* > > *LINE 9: where mg.annee_univ = v.annee and mg.semestre = v.sem_civ* > > * ^* > > *HINT: There is an entry for table "v", but it cannot be referenced from > this part of the query.* > > > > > > > -- Helio Campos Mello de Andrade