Looks like there's a standard XML way of returning query results:
http://www.w3.org/TR/2005/WD-rdf-sparql-XMLres-20050801/
Chris
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Ian Westmacott <[EMAIL PROTECTED]> writes:
> In a nutshell, I have a LIMIT query where the planner
> seems to favor a merge join over a nested loop.
The planner is already estimating only one row out of the join, and so
the LIMIT doesn't affect its cost estimates at all.
It appears to me that the
Simon Riggs <[EMAIL PROTECTED]> writes:
> I agree with everything you just said.
As AndrewSN already pointed out, the argument is all wet because it
ignores the use of OIDs for toasted values ... not to mention large
objects. Yeah, it would take a while to wrap the counter, but it's
hardly out of
On Wed, 2005-08-10 at 14:42 -0400, Greg Stark wrote:
> Bruce Momjian writes:
>
> > Just to chime in --- I have been surprised how _few_ complaints we have
> > gotten about oid wraparound hitting system table oid conflicts. I agree
> > that telling people to retry their CREATE statements isn't re
On Wed, 10 Aug 2005, elein wrote:
> implementation of the SQL-3 standard for multi-value NULLs
> for PostgreSQL?
SQL-3, that's what became sql99, isn't it?
Anyway, there is nothing like what you explained in sql 99 nor sql 2003.
The boolean type have a third value called UNKNOWN that is just a
Matt Miller <[EMAIL PROTECTED]> writes:
> It seems to me that contrib/dblink could greatly simplify the design and
> coding of multi-user regression tests. Is there objection to a portion
> of src/test/regress depending on contrib/dblink?
Yes. Given the difficulties we had in getting the contrib
On Wed, 2005-08-10 at 11:26 -0400, Andrew Dunstan wrote:
> Tom Lane wrote:
> >Simon Riggs <[EMAIL PROTECTED]> writes:
> >
> >>On a related topic, why is pg_config not part of the RPM builds?
> >
> >Hmm? It's definitely in Red Hat's RPMs, can't speak for anyone else's.
> >
> >(Red Hat puts it in
Bcc:
Subject: Multi-valued NULLS
Reply-To:
Can someone tell me what is the current discussion is on the
implementation of the SQL-3 standard for multi-value NULLs
for PostgreSQL?
http://diuf.unifr.ch/ds/courses/db/pdf/whysql3.htm
Quote from that document:
You will have noticed that the BOOL
On Mon, 2005-08-08 at 16:59 -0400, Tom Lane wrote:
> Matt Miller <[EMAIL PROTECTED]> writes:
> > I want to write some regression tests that confirm the behavior of
> > multiple connections simultaneously going at the same tables/rows. Is
> > there something like this already, e.g. in src/test/regr
On 2005-08-10, Greg Stark <[EMAIL PROTECTED]> wrote:
> But with no OIDs on user tables it must take a really long time for this to
> happen. I mean, even if you have thousands of tables you would have to go
> through thousands (many thousands even) of dump/reload cycles before you push
> oid to 4 b
Bruce Momjian writes:
> Just to chime in --- I have been surprised how _few_ complaints we have
> gotten about oid wraparound hitting system table oid conflicts. I agree
> that telling people to retry their CREATE statements isn't really an
> ideal solution, and the idea of looping to find a fr
On 2005-08-10, Tom Lane <[EMAIL PROTECTED]> wrote:
> Andrew - Supernews <[EMAIL PROTECTED]> writes:
>>> If a SCSI drive reports write complete when it hasn't actually put the
>>> bits on the platter yet, then it's simply broken.
>
>> I guess you haven't read the spec much, then.
>
> [ shrug... ] I
Tom Lane wrote:
Simon Riggs <[EMAIL PROTECTED]> writes:
On a related topic, why is pg_config not part of the RPM builds?
Hmm? It's definitely in Red Hat's RPMs, can't speak for anyone else's.
(Red Hat puts it in the postgresql-devel RPM, which might be a poor
choice, but it's ther
On Tue, Aug 09, 2005 at 10:54:49PM +0200, Soeren Laursen wrote:
> Hi,
>
> I am programming a new set of functions for manipulation blobs, one
> of the functions is that I want to get the size of the blob.
Huh, we don't call them "blobs". They are "large objects" in
PostgreSQL.
> I have used oth
On Tue, Aug 09, 2005 at 10:54:49PM +0200, Soeren Laursen wrote:
> I have used other function calls like
> inv_open with no problem, but when I load this modules I get:
>
> undefined symbol: inv_getsize
Notice the word "static" in the definition of inv_getsize() in
src/backend/storage/large_object
Simon Riggs <[EMAIL PROTECTED]> writes:
> On a related topic, why is pg_config not part of the RPM builds?
Hmm? It's definitely in Red Hat's RPMs, can't speak for anyone else's.
(Red Hat puts it in the postgresql-devel RPM, which might be a poor
choice, but it's there.)
Hi,
I am programming a new set of functions for manipulation blobs, one
of the functions is that I want to get the size of the blob.
The function is coded in C and goes like this:
Datum
blob_size(PG_FUNCTION_ARGS)
{
Oid blob_oid = PG_GETARG_OID(0);
uint32 blobsize = 0;
blobsize = inv_getsi
On Tue, 2005-08-09 at 14:49 -0400, Tom Lane wrote:
> Currently, pg_config will tell about the configure options that were
> used, but it does not let you find out if any environment variables were
> used to determine CC, CFLAGS, etc. More than once I've found myself
> wanting to verify that inform
Simon Riggs wrote:
On Tue, 2005-08-09 at 16:01 +0100, Richard Huxton wrote:
Tom Lane wrote:
What if there aren't any "untouched chunks"? With only 64K-chunk
granularity, I think you'd hit that condition a lot more than you are
hoping. Also, this seems to assume uniqueness across all tables
I was recently witness to a benchmark of 7.4.5 on Solaris 9 wherein
it was apparently demonstrated that fsync was the fastest option
among the 7.4.x wal_sync_method options.
If there's a way to make this information more useful by providing
more data, please let me know, and I'll see what I
20 matches
Mail list logo
