> > Example with variant_id = 2
> >
> > slygreetings=> explain select * from users where variant_id=2 AND
> > active='f' order by rcptdate limit 60;
> > NOTICE: QUERY PLAN:
> >
> > Limit (cost=77117.18..77117.18 rows=60 width=145)
> > -> Sort (cost=77117.18..77117.18 rows=162640 width=145)
>
On Saturday 06 January 2001 20:21, Tom Lane wrote:
> "Robert B. Easter" <[EMAIL PROTECTED]> writes:
> > What is the syntax for this? Is there an example I can see/run?
>
> SQL92 standard.
>
> See
> http://www.postgresql.org/devel-corner/docs/postgres/sql-select.htm
> for documentation (such as it
On Sat, 6 Jan 2001, Robert B. Easter wrote:
> What is the syntax for this? Is there an example I can see/run?
Should follow standard SQL92 syntax (which, BTW, Oralce doesn't):
SELECT * FROM table1 LEFT OUTER JOIN table2 ON (table1.field =
table2.field)
This will return all rows from table1 ev
"Robert B. Easter" <[EMAIL PROTECTED]> writes:
> What is the syntax for this? Is there an example I can see/run?
SQL92 standard.
See
http://www.postgresql.org/devel-corner/docs/postgres/sql-select.htm
for documentation (such as it is). There are some examples in the
join regression test, too.
Can I see your function that tried to do it? Pg 7.1 beta has a new EXECUTE
statement for PL/pgSQL that allows execution of a query string that can be
created dynamically (see the development docs at www.postgresql.org). It
might be relevant to your problem.
On Friday 05 January 2001 03:59, g
What is the syntax for this? Is there an example I can see/run?
On Thursday 04 January 2001 04:30, Poul L. Christiansen wrote:
> PostgreSQL 7.1 (which is in beta now) will have outer joins.
>
> It will probably (and hopefully) be released in Jan./Feb., but the beta
> seems quite stable to me.
>
On Sat, 6 Jan 2001, Tom Lane wrote:
> Yeah, but those files are only half the truth. The other half lives in
> pg_log and the installation-wide tables (pg_database, etc). George is
> correct: you cannot recover using only the contents of $PGDATA/base/foo.
> You really need all of $PGDATA.
Real
"Brett W. McCoy" <[EMAIL PROTECTED]> writes:
> On Sat, 6 Jan 2001, George Johnson wrote:
>> So basically, I've wiped all my databases, it looks like, and no, there is
>> no directory/structure which atomically can be called "your database", other
>> than the ENTIRE data/base directory.
> Sure the
On Sat, 6 Jan 2001, George Johnson wrote:
> So basically, I've wiped all my databases, it looks like, and no, there is
> no directory/structure which atomically can be called "your database", other
> than the ENTIRE data/base directory.
Sure there is -- under my $PGHOME/data/base, each separate
Hello Everybody,
I've been whirling along with my new postgresql database (converted from
mysql before Christmas) and have been very pleased. Until a few days ago .
I was sittin there minding my own business WHEN ... (dot dot dot)
I was goofing around attempting to install new UDF's and in the
At 19:14 4/01/01 -0600, Matthew wrote:
>I posted a note to the hackers list about this very issue last week. It was
>never responded to. I am prepared to do the work and submit a patch, but I
>wanted some input on how best to do it. We had a problem with a backup
>script silently failing when t
Hi
I think You misunderstand the function You use. What was You expect to get
when You try to access to not exsisting row? When You are doing "while" it
will exit on ``false'' value - so when You access to not existing row the
function produce ``false'', but also PHP produce Error message if You
12 matches
Mail list logo
