OK I know this is an odd question but I'm working on an app that will rely
more and more on database driven functions, and while the app's source is
in SVN, and I intend for the source of the SQL scripts to also be there, I
was wondering...what are people doing for version control and change
ma
--On July 7, 2006 12:35:53 PM + Roman Neuhauser <[EMAIL PROTECTED]>
wrote:
# [EMAIL PROTECTED] / 2006-07-06 22:41:27 -0600:
OK I know this is an odd question but I'm working on an app that will
rely more and more on database driven functions, and while the app's
source is in SVN, and
OK I'm either insane or found a bug in 8.1.3
If you execute say:
SELECT DISTINCT(ua.user_id),pa.poll_id FROM user_answers ua, poll_answers
pa WHERE pa.poll_answer_id = ua.poll_answer_id AND ua.active='Y';
Everything is fine, however if you run
SELECT pa.poll_id,DISTINCT(ua.user_id) FROM user
--On July 7, 2006 3:22:01 PM -0700 Richard Broersma Jr
<[EMAIL PROTECTED]> wrote:
Notice: http://www.postgresql.org/docs/8.1/interactive/sql-select.html
According to the syntax for a select a distinct | distinct on must be the
first column specified in the syntax.
So perhaps it is designed
I'm resending this to -general. I'd originally sent it to -hackers.
I've been waiting for atleast one more person to sign up for the training
so OTG can confirm this class down there, they said that some of the
internal hackers had requested the course out there, so I wanted to ping
everyone
In mySQL there is an INSTR(arg1,arg2) function that takes and looks for any
of the characters in arg1 and matches them against arg2
IE are the characters A or B or C or D in the string "dogma" would be
INSTR('ABCD','dogma');
Anyone help me to produce this sort of logic in an PSQL select statemen
Thanks much! I never even realised pg had regex built in.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 2:50 PM
To: Michael Loftis
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] INSTR() like function?
"Michael Loftis" <[EM