Re: [SQL] Alternative to INTERSECT

I don't know if this is more efficient but an alternative can be something like this SELECT t.id FROM test t JOIN test t2 ON t2.id = t.id AND t2.field = 'firstname' AND t2.value LIKE 'jose%' JOIN test t3 ON t3.id = t2.id AND t3.field = 'lastname' AND t3.value LIKE 'kro%' WHERE t.field = '

Re: [SQL] Authentification failed

On 8/1/07, Judith <[EMAIL PROTECTED]> wrote: > Hello everybody!! > > I'm trying in SUSE to connect to a postgres db and this is the error: > > Ident Authentification failed for user <> > > I'm already created the user with createuser root, but the error > persist, I would aprecciate some help

Re: [SQL] Authentification failed

> I'm trying in SUSE to connect to a postgres db and this is the > error: > > Ident Authentification failed for user <> > others will guide better, but for now, in pg_hba.conf # "local" is for Unix domain socket connections only local all all iden

[SQL] Authentification failed

Hello everybody!! I'm trying in SUSE to connect to a postgres db and this is the error: Ident Authentification failed for user <> I'm already created the user with createuser root, but the error persist, I would aprecciate some help, thanks in advanced ---(end of

Re: [SQL] How do I connect postgres table structures and view structures to an existing svn repository?

On Aug 1, 2007, at 1:17 PM, D'Arcy J.M. Cain wrote: On Wed, 1 Aug 2007 11:46:11 -0500 "Scott Marlowe" <[EMAIL PROTECTED]> wrote: On 8/1/07, John Mitchell <[EMAIL PROTECTED]> wrote: I am trying to store schema definitions in version-control which I can do by saving the definition and then im

Re: [SQL] How do I connect postgres table structures and view structures to an existing svn repository?

On Wed, 1 Aug 2007 11:46:11 -0500 "Scott Marlowe" <[EMAIL PROTECTED]> wrote: > On 8/1/07, John Mitchell <[EMAIL PROTECTED]> wrote: > > I am trying to store schema definitions in version-control which I can do by > > saving the definition and then importing into svn, but I would like it > > to b

Re: [SQL] How do I connect postgres table structures and view structures to an existing svn repository?

On 8/1/07, John Mitchell <[EMAIL PROTECTED]> wrote: > I am trying to store schema definitions in version-control which I can do by > saving the definition and then importing into svn, but I would like it > to be automatic , so that when an update occurs to a table or view within > postgres then

Re: [SQL] How do I connect postgres table structures and view structures to an existing svn repository?

On Wed, 1 Aug 2007 11:45:21 -0400 "John Mitchell" <[EMAIL PROTECTED]> wrote: > I am trying to store schema definitions in version-control which I can do by > saving the definition and then importing into svn, but I would like it > to be automatic , so that when an update occurs to a table or vi

Re: [SQL] How do I connect postgres table structures and view structures to an existing svn repository?

On Wed, 1 Aug 2007 10:07:31 -0400 "John Mitchell" <[EMAIL PROTECTED]> wrote: > How do I connect postgres table structures and view structures to an > existing svn repository? I'm not sure that I understand the connection between SQL and SVN. Can you be a bit clearer about what you are trying to d

Re: [SQL] How do I connect postgres table structures and view structures to an existing svn repository?

I am trying to store schema definitions in version-control which I can do by saving the definition and then importing into svn, but I would like it to be automatic , so that when an update occurs to a table or view within postgres then that table or view is flagged within svn. This would be si

[SQL] How do I connect postgres table structures and view structures to an existing svn repository?

Hi, How do I connect postgres table structures and view structures to an existing svn repository? Thanks, -- John J. Mitchell