On Mon, May 06, 2013 at 02:16:38PM +1200, Tim Uckun wrote:
Say I have a select like this.
SELECT * FROM table where field = X OR field = Y limit 1
And I have two records one that matches X and one that matches Y will I
always get X because the evaluation will stop after the first clause in
On Fri, Apr 26, 2013 at 11:01:28AM +0200, CR Lender wrote:
Is there any way to ensure that all donors and recipients in eu_loans
are in the EU, without altering the countries and persons tables?
One way to do this would be to add countries to the eu_loans table so
it looks like this:
create
On Sun, Jan 30, 2005 at 03:21:25PM -0500, Rick Apichairuk wrote:
I am trying to increase the number of max_connections to 200 and found
out I couldn't even start postgresql. So I tried to increase
max_connections gradually (currently at 50 from 40 default) and adjust
shared memory settings
On Tue, Jan 25, 2005 at 12:29:07PM -0800, Ben wrote:
select
coalesce(a.n,0) as a,
coalesce(b.n,0) as b,
coalesce(c.n,0) as c,
coalesce(a.s,b.s,c.s) as s
from
( select 1 as n, 0 as s) a full outer join
( select 1 as n, 1 as s) b full outer join
(
On Sat, Jan 22, 2005 at 02:03:58PM -0700, Ed L. wrote:
There's probably an obvious answer for this, but I couldn't see it in the
docs. What's the simplest way to concatenate multiple same-column values
in SQL?
You can create an aggregate that does nothing but concatenate the entries:
On Thu, Oct 28, 2004 at 03:36:00PM -0400, Robert Fitzpatrick wrote:
I would like all those on the same street grouped together. Is there any
tricks to getting the street names sorted first, possibly where numbers
and strings separate?
You could do something like
CREATE FUNCTION
On Tue, Jun 08, 2004 at 05:51:22PM -0400, Michelle Murrain wrote:
I'd like to make 'courseid' in this second table a foreign key,
referencing 'courseid' in the first table. So I did this command:
charter_dev2=# ALTER TABLE coursesevaluations ADD CONSTRAINT rc_ce
FOREIGN KEY (courseid)
On Mon, Jun 07, 2004 at 02:29:33PM -0700, Dennis Gearon wrote:
I have the following code from an application that is 'mysql_centric'. I
want to make it generic across all databases, if it's possible,
especially postgres :-)
mysql version:
INSERT INTO calendar_setting SET
On Fri, Jul 18, 2003 at 08:26:59AM -0300, Vilson farias wrote:
Greetings,
I've been fighting against a very strange behaviour found in PostgreSQL
7.1.2 on a RedHat 6.2. I have a very simple table called site_site and I
lost it's indexes everytime I run a vaccum. Do you know why this
On Wed, Feb 07, 2001 at 06:53:13AM -0600, Jamie Bumsted wrote:
Hi All,
I am new to pgsql, I have inherited a database with no documentation, i.e.
nobody knows the passwords for any of the database accounts. Anybody have
any ideas on how to change the passwords without first knowing the
On Wed, Nov 01, 2000 at 12:32:58PM -0500, Nick Fankhauser wrote:
According to the documentation and Bruce M's book, there is no limit. I've
never hit a limit while putting some pretty large (three page) narratives in
a text field.
There is no limit on the "text" type as such, but there is
Apologies to anyone who has already seen this once; I sent it about
the time that many of us seemingly stopped receiving mail from the
list, so I don't know whether most people got it or not.
I've found what may be a bug in initdb, a bug in its documentation, a
misunderstanding on my part, or a
On Wed, Jul 05, 2000 at 11:13:45PM -0300, The Hermit Hacker wrote:
On Wed, 5 Jul 2000, Jim Wise wrote:
I'd like to point out a couple things that are _not_ wrong with the
current license:
1.) With the current license, contributors to the code are not opened
to legal liability
13 matches
Mail list logo