How can it be a simple 8 byte int or float and specify a timezone?
This is only a time interval from a fixed date/time. Where is the
timezone part?
On Nov 8, 2007, at 7:18 AM, Tom Lane wrote:
Samantha Atkins <[EMAIL PROTECTED]> writes:
What can I expect for a date format from a PGresult
This brings up a second question. How should I do byte order
conversion for 8 byte ints? I can't use hton ntoh routines as they
max out at 32 bits. Is there a better way? Also, are floating point
numbers guaranteed uniform?
If any one knows a a clean code example of binary binding of
Kris Jurka <[EMAIL PROTECTED]> writes:
> I think the expectation is that:
> CREATE TABLE t(a int, b int);
> INSERT INTO t(b,a) VALUES (1,2) RETURNING *;
> will return 1,2 instead of 2,1 as it does now.
Hmm ... I see your point, but on what grounds could one argue that
a "*" targetlist here shoul
I've a multithread application running on Linux. In each thread i've a loop
performing a single INSERT operation on the DB.
Sometimes (not always), two of the three thread die apparently without any
reason. The strange thing is that if I remove the store operation from
the threads, all runs fine. V
On Wed, 12 Dec 2007, Tom Lane wrote:
Every few weeks we get a complaint from someone who thinks that it
should be easy to rearrange the logical order of table columns.
If that comes to pass, it would be a seriously bad idea to have
encouraged applications to rely on table column numbers.
I t
On 12/11/07, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> Now, a gripe rightly attributable to the to PG mailing list setup is
> that every time I reply, I have to:
>
> (1) use reply all, because reply is set to go to the individual rather
> than the list
>
> (2) delete all the individual addressees
On 12/11/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> On Tue, 11 Dec 2007 06:48:35 -0800
> "Keith Turner" <[EMAIL PROTECTED]> wrote:
> > I apologize; I had assumed that the threads were simply grouped by
> > subject. If this is such a problem, probably it should be laid out on
> > the list in
Ken Johanson <[EMAIL PROTECTED]> writes:
> While the values of an API that specifies the table's columns by
> ordinaility may seem dubious, it is an API that I think should be
> implemented anyway.
Every few weeks we get a complaint from someone who thinks that it
should be easy to rearrange the
"Chris Velevitch" <[EMAIL PROTECTED]> writes:
> I'm trying to understand the explain output, but I can't find any
> references to the meanings of the following terms:-
> merge join
> nested loop
> merge left join
> nested loop left join
http://developer.postgresql.org/pgdocs/po
I am attempting to implement (in a driver)(PG JDBC) support for
specifying which column indexes (that generated keys) to return, so I'm
searching for a way to get the server to return the values of the
columns by their index, not name. By name, it is simply to append the
RETURNING clause and co
I'm trying to understand the explain output, but I can't find any
references to the meanings of the following terms:-
merge join
nested loop
merge left join
nested loop left join
I'm using 7.4.
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 041
--- On Tue, 12/11/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Also see the overview at
> http://www.postgresql.org/docs/8.3/static/xaggr.html
Thanks Tom!
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
Gregory Williamson wrote:
* a lot of us have to use what ever the company provides as mail server.
Exchange sucks but I'd rather not quit my job just because _you_ have a
problem reading mail that does not conform to the "T" to your
expectations.
I'm guessing you use Outlook to connect to you
> "Matt Magoffin" <[EMAIL PROTECTED]> writes:
>> Thanks very much, that helps. Now I'm wondering if it's also possible to
>> then fill in another nested element level in the XML output, from the
>> rows
>> that are aggregated into the count.
>
> Something involving xmlagg in the sub-query, perhaps
On Dec 11, 2007 9:55 PM, Magicloud Wang <[EMAIL PROTECTED]> wrote:
> Dear,
> I think database has its own operation journal, and different journal
> filesystem does give different performance. So if I put database file on a
> non-journal filesystem, would it be safe? Does this like using a
For those interested in the I/O results (as reported by iostat) of
moving where the stats files are written (using the method I
described in http://archives.postgresql.org/pgsql-general/2007-12/
msg00106.php) on our production system: service time has dropped from
an average of 95.76ms to ab
Dear,
I think database has its own operation journal, and different journal
filesystem does give different performance. So if I put database file on a
non-journal filesystem, would it be safe? Does this like using a raw device?
Thanks.
---(end of broadcast)--
Ivan Sergio Borgonovo wrote:
On Tue, 11 Dec 2007 12:00:00 -0600
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
You're certainly not. I can't tell you how many times I've
carefully replied to someone with inline quoting, only to get some
top post response. I then ask them politely not to top post,
Tom Lane wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
... Now I understand that restoring log files can be slow but this is a big
machine.
Yeah, restoring is known to be less than speedy, because essentially
zero optimization work has been done on it.
Heikki has improved matters a bit
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> ... Now I understand that restoring log files can be slow but this is a big
> machine.
Yeah, restoring is known to be less than speedy, because essentially
zero optimization work has been done on it.
Heikki has improved matters a bit in 8.3, but I
"Matthew Dennis" <[EMAIL PROTECTED]> writes:
> http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html is for
> 8.3 where there were some changes to the number of arguments an aggregate
> could take. I believe it's also more descriptive documentation.
Also see the overview at
http://ww
--- On Tue, 12/11/07, Matthew Dennis <[EMAIL PROTECTED]> wrote:
> http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html
> is for
> 8.3 where there were some changes to the number of
> arguments an aggregate
> could take. I believe it's also more descriptive
> documentation.
>
> of c
All,
I want to use the ENCRYPT and DECRYPT functions from contrib, but they
require inputs of BYTEA.
My data is in VARCHAR and TEXT fields and when I try to use the contrib
functions, they complain about wrong datatypes. Is there a string
function or something that will take a VARCHAR or TE
Hello,
I have an interesting thing going on here...
2007-12-11 21:10:36 EST LOG: restored log file
"000107CC0012" from archive
2007-12-11 21:10:47 EST LOG: restored log file
"000107CC0013" from archive
2007-12-11 21:11:02 EST LOG: restored log file
"
On 12/11/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
>
> Is it possible to create aggregate functions using pl/pgsql?
Yes, the sfunc and ffunc can be functions written in plpgsql.
If not possible in plpgsql, is there any other way to create these types of
> functions?
Yes, but I don't k
Thomas Hart wrote:
Andrew Sullivan wrote:
I don't think top posting is always the crime it's made to be (and I
get a
little tired of lectures to others about it on these lists).
A
I agree. Obviously there is convention, and I will post in the style
generally accepted in the list, but to
Is it possible to create aggregate functions using pl/pgsql?
If not possible in plpgsql, is there any other way to create these types of
functions?
If anyone could point to the correct documentation I would be most appreciative.
Regards,
Richard Broersma Jr.
---(end of
"Matt Magoffin" <[EMAIL PROTECTED]> writes:
> Thanks very much, that helps. Now I'm wondering if it's also possible to
> then fill in another nested element level in the XML output, from the rows
> that are aggregated into the count.
Something involving xmlagg in the sub-query, perhaps? No time
On Tuesday 11 December 2007 16:11, Scott Marlowe wrote:
> read the old
> messages in this thread, you'll see that I too said it was perfectly
> acceptable some times. Things like "Thanks, that solved it!" are fine
> top posted, although you really should crop the majority of the
> message you're
Marc Munro <[EMAIL PROTECTED]> writes:
> This works fine:
> "str2"varchar(40)
> This does not:
> "str2""pg_catalog"."varchar"(40)
Yeah. That's because in all existing PG releases, type modifiers are
handled by hard-wired grammar productions that *only* work
Hi all,
I run a PostgreSQL 8.1 server that hosts two main applications -- both
web-based OLTP-type work -- with a few databases for each. I'm currently
using pg_dump for backups, but the clients for one of the applications
we're hosting as asked to be moved to PITR because they like the idea o
On Tue, 2007-11-12 at 19:32 -0500, Tom Lane wrote:
> Marc Munro <[EMAIL PROTECTED]> writes:
> > This works fine:
> > "str2"varchar(40)
> > This does not:
> > "str2""pg_catalog"."varchar"(40)
>
> Yeah. That's because in all existing PG releases, type modifie
Greg Stark shaped the electrons to read:
> "Obe, Regina" <[EMAIL PROTECTED]> writes:
>
> > Well said Greg. I have the same problem too of having a crippled mail
> > reader :) Really I find mid posting hard to follow especially if I'm
> > the one that posted the question. I hope we aren't going
I recently discovered the hashtext() function, and I'm interested in using
> it to reduce the size of one of the biggest indexes in my database.
>
...
The problem with either MD5 or hashtext() is that neither can guarantee
> unique output even if the inputs are all unique.
>
...
>
> The problem I
"Obe, Regina" <[EMAIL PROTECTED]> writes:
> Well said Greg. I have the same problem too of having a crippled mail
> reader :) Really I find mid posting hard to follow especially if I'm
> the one that posted the question. I hope we aren't going to hit people
> with hammers over this minor infra
On Tue, 11 Dec 2007, Collin Kidder wrote:
I believe that my conforming to the "rule" shows that I am willing to
cater to the wishes of the overly anal people on this list. That they
cannot allow any deviation from their narrow mindset shows you that the
real problem we've been talking about is
On Tue, 11 Dec 2007 12:00:00 -0600
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> You're certainly not. I can't tell you how many times I've
> carefully replied to someone with inline quoting, only to get some
> top post response. I then ask them politely not to top post, fix
> the format, reply,
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Howard Cole
> Sent: Tuesday, December 11, 2007 2:21 PM
> To: 'PgSql General'
> Subject: Re: [GENERAL] Killing a session in windows
>
> Hello everyone,
>
> I take it from the lack of resp
> "Matt Magoffin" <[EMAIL PROTECTED]> writes:
>> Hello, I'm trying to write a query to return an XML document like
>>
>>
>>
>> ...
>>
>
> Something like this:
>
> regression=# select xmlelement(name root, xmlagg(x)) from
> regression-# (select xmlelement(name range, xmlattributes(string
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Howard Cole wrote:
>> I take it from the lack of response that nobody knows how to kill a
>> connection from the postgresql side on windows?
> You can't, short of sending a signal to the process or restarting the
> service.
Which you can do, no? I th
Howard Cole wrote:
> Hello everyone,
>
> I take it from the lack of response that nobody knows how to kill a
> connection from the postgresql side on windows?
You can't, short of sending a signal to the process or restarting the
service.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49'
Hello everyone,
I take it from the lack of response that nobody knows how to kill a
connection from the postgresql side on windows? Is there another way
around this? In the end I created another database and changed all my
code to use the new database, the original database is still there (now
On 11/12/2007 17:41, Bill Moran wrote:
Again, you're asking a community to offer you free help in spite of the
fact that your tools suck. I'm not saying nobody will do it, all I'm
saying is that if you make it too difficult for people to help, they
won't.
I think this is the most important po
--- On Tue, 12/11/07, Pau Marc Munoz Torres <[EMAIL PROTECTED]> wrote:
> Thanks, i'll test it tomorrow
OOPS, I just noticed a mistake.
INSERT INTO SP
SELECT a, b
FROM ( VALUES ( 'cesp', 'sp' )) AS tmp( a, b )
LEFT JOIN Sp
ON (Sp.col1,Sp.col2)=(tmp.a,tmp.b)
WHERE (Sp.
Thanks, i'll test it tomorrow
pau
2007/12/11, Richard Broersma Jr <[EMAIL PROTECTED]>:
>
> --- On Tue, 12/11/07, Pau Marc Munoz Torres <[EMAIL PROTECTED]> wrote:
> > could i use a sentence similar to the mysql sentence
> >
> > insert if not exist into SP values
> > ('cesp','sp');
> >
> > in postg
Well said Greg. I have the same problem too of having a crippled mail
reader :) Really I find mid posting hard to follow especially if I'm
the one that posted the question. I hope we aren't going to hit people
with hammers over this minor infraction. It really makes one feel
unwelcome.
I gues
> -Original Message-
> From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 11, 2007 1:11 PM
> To: Dann Corbit
> Cc: [EMAIL PROTECTED]; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Dumb question about binary cursors and
> #ifdefHAVE_INT64_TIMESTAMP
>
> Dann Cor
> -Original Message-
> From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 11, 2007 1:11 PM
> To: Dann Corbit
> Cc: [EMAIL PROTECTED]; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Dumb question about binary cursors and
> #ifdefHAVE_INT64_TIMESTAMP
>
> Dann Cor
On Tue, 11 Dec 2007 12:00:00 -0600
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> You're certainly not. I can't tell you how many times I've
> carefully replied to someone with inline quoting, only to get some
> top post response. I then ask them politely not to top post, fix
> the format, reply,
I agree with Joshua on this point. It's entirely possible to discuss
this without resorting to immaturity. If you make a decent point, then
diminish it by cursing or insulting everybody here, you've lost the
point and it's effectiveness entirely.
Yes, once again, I apologize. At times I se
Dann Corbit wrote:
> If I create a binary cursor on a recent version of PostgreSQL, how can I
> tell if the timestamp data internally is an 8 byte double or an 8 byte
> integer?
>
> I see an #ifdef that changes the code path to compute timestamps as one
> type or the other, but I do not know how t
"Dann Corbit" <[EMAIL PROTECTED]> writes:
> If I create a binary cursor on a recent version of PostgreSQL, how can I
> tell if the timestamp data internally is an 8 byte double or an 8 byte
> integer?
PQparameterStatus(conn, "integer_datetimes")
regards, tom lane
On Dec 11, 2007 1:01 PM, Collin Kidder <[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
> > On Dec 11, 2007 11:41 AM, Leif B. Kristensen <[EMAIL PROTECTED]> wrote:
> >
> >> It certainly isn't a crime. But it's a bit like thread hijacking in the
> >> sense that a well-formed inline posting is more
On Dec 11, 2007, at 2:58 PM, Collin Kidder wrote:
Geoffrey wrote:
Collin Kidder wrote:
I have to suffer through dealing with people like the two of you
quoted above. You can deal with people who'd like to top post.
Anything else is just being a spoiled baby who can't deal with
minor iss
On Dec 11, 2007 2:58 PM, Collin Kidder <[EMAIL PROTECTED]> wrote:
> Geoffrey wrote:
> > Collin Kidder wrote:
> >
> >> I have to suffer through dealing with people like the two of you
> >> quoted above. You can deal with people who'd like to top post.
> >> Anything else is just being a spoiled baby
In response to Collin Kidder <[EMAIL PROTECTED]>:
> Geoffrey wrote:
> > Collin Kidder wrote:
> >
> >> I have to suffer through dealing with people like the two of you
> >> quoted above. You can deal with people who'd like to top post.
> >> Anything else is just being a spoiled baby who can't dea
If I create a binary cursor on a recent version of PostgreSQL, how can I
tell if the timestamp data internally is an 8 byte double or an 8 byte
integer?
I see an #ifdef that changes the code path to compute timestamps as one
type or the other, but I do not know how to recognize the internal
format
Collin Kidder wrote:
Geoffrey wrote:
Collin Kidder wrote:
I have to suffer through dealing with people like the two of you
quoted above. You can deal with people who'd like to top post.
Anything else is just being a spoiled baby who can't deal with minor
issues. If all the energy spent cryin
I felt I was 'responding in kind' wrt 'it really irritates me when
people cry like 4 year olds about top posting. It's not that bad, get
over it.' posting. My apologies if I've taken it to a level of rude
that it had not already reached.
I suppose that the post was probably directed at
On Dec 11, 2007, at 1:44 PM, Gregory Stark wrote:
"Andrew Sullivan" <[EMAIL PROTECTED]> writes:
I would argue that this message is harder to read than if I'd just
replied
at the top. It's pointlessly long -- but without including
everything, you
wouldn't have all the context, and you mi
Geoffrey wrote:
Collin Kidder wrote:
I have to suffer through dealing with people like the two of you
quoted above. You can deal with people who'd like to top post.
Anything else is just being a spoiled baby who can't deal with minor
issues. If all the energy spent crying about top posting we
Joshua D. Drake wrote:
Geoffrey wrote:
Collin Kidder wrote:
I have to suffer through dealing with people like the two of you
quoted above. You can deal with people who'd like to top post.
Anything else is just being a spoiled baby who can't deal with minor
issues. If all the energy spent cry
Geoffrey wrote:
Collin Kidder wrote:
I have to suffer through dealing with people like the two of you
quoted above. You can deal with people who'd like to top post.
Anything else is just being a spoiled baby who can't deal with minor
issues. If all the energy spent crying about top posting we
Collin Kidder wrote:
I have to suffer through dealing with people like the two of you quoted
above. You can deal with people who'd like to top post. Anything else is
just being a spoiled baby who can't deal with minor issues. If all the
energy spent crying about top posting were used to fuel c
On Dec 11, 2007 3:35 PM, smiley2211 <[EMAIL PROTECTED]> wrote:
> Thanks...Michelle
Please post DDL plus sample code/data to increase the odds of having
someone help you.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Steve Atkins wrote:
In the business world it's common to top-post and not cut previous content
- and often appropriate, as it tends to be a communication between a
smaller number of people, and the uncut content provides context for
future reference.
And it is quite common for tractor trailers
ex:
CREATE TRIGGER mytrig AFTER INSERT OR UPDATE ON foo1 FOR EACH ROW EXECUTE
PROCEDURE updatefoo1('datarow');
The command itself is able to be executed without error. However, what then
happens, is that whenever the application attempts to insert a record into
foo1, it simply doesn't insert. On
Richard Huxton <[EMAIL PROTECTED]> writes:
>>> [EMAIL PROTECTED] wrote:
Does someone know if there is some kind of incompatibility between
POSIX (glibc 2.4) and libpq (postgres 8.2) on Linux RedHat 5.0?
>>> Do you really mean RedHat 5.0 - the one released in 1997?
>> Sorry, my informat
Thomas Hart wrote:
As an illustration, which helps you understand the preceding
paragraph better, the extract above, or the mess below?
You raise some good points, and I agree with them. However if you
want to have an intelligent conversation, try not to load it with
questions like "Do yo
On Tuesday 11 December 2007 12:23, Andrew Sullivan wrote:
> On Tue, Dec 11, 2007 at 09:00:05AM -0800, Joshua D. Drake wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > On Tue, 11 Dec 2007 11:49:54 -0500
> >
> > Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> > > On a mailing list, p
On Tuesday 11 December 2007 12:23, Andrew Sullivan wrote:
> Simply replying to an argument with an assertion to the contrary is, I
> think, dogmatism. The argument for top posting is that it is _easier_ to
> read for certain kinds of cases. I have already rehearsed those arguments;
> I think they
On Tue, Dec 11, 2007 at 07:44:31PM +, Gregory Stark wrote:
> Seriously, do you have any trouble following the discussion even though I
> only clipped two sentences of your message? If you did would you have any
> trouble finding the original message to reread it?
No, but (1) I have been doing
"Andrew Sullivan" <[EMAIL PROTECTED]> writes:
> I would argue that this message is harder to read than if I'd just replied
> at the top. It's pointlessly long -- but without including everything, you
> wouldn't have all the context, and you might have missed something.
We're not goldfish, we
John D. Burger wrote:
Thomas Hart wrote:
I agree. Obviously there is convention, and I will post in the style
generally accepted in the list, but to me it always made more sense
to top post. If you're keeping up on the conversation, then the
relevant information is right there, and if you wer
It seems that in create table I cannot specify the schema of a built-in
type that has a length specifier. Nor can I double-quote the type name.
Is this correct/expected behaviour, and are there work-arounds?
This works fine:
create table "public"."additional" (
"str1""pg_catalo
[EMAIL PROTECTED] wrote:
Does someone know if there is some kind of incompatibility between
POSIX
(glibc 2.4) and libpq (postgres 8.2) on Linux RedHat 5.0?
Do you really mean RedHat 5.0 - the one released in 1997?
> Sorry, my information was not complete.
> The Linux version is Linux AS 5.0
Thomas Hart wrote:
I agree. Obviously there is convention, and I will post in the
style generally accepted in the list, but to me it always made more
sense to top post. If you're keeping up on the conversation, then
the relevant information is right there, and if you weren't, it's
not tha
joining column's datatypes do not
>match
>
>
>
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Fai squillare la PANTERA ROSA sul tuo cellulare: e' in REGALO
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6613&
Collin Kidder wrote:
Scott Marlowe wrote:
On Dec 11, 2007 11:41 AM, Leif B. Kristensen <[EMAIL PROTECTED]> wrote:
I have to suffer through dealing with people like the two of you quoted
above. You can deal with people who'd like to top post. Anything else is
just being a spoiled baby who can
Scott Marlowe wrote:
On Dec 11, 2007 11:41 AM, Leif B. Kristensen <[EMAIL PROTECTED]> wrote:
It certainly isn't a crime. But it's a bit like thread hijacking in the
sense that a well-formed inline posting is more likely to attract
intelligent replies. I don't think that I'm the only one who t
You are quite right, and I must admit that I messed up one more time on this
one.
I chose an alias, which was already a column name in one of the relations,
so the results were rubbish anyhow.
Took me some time to figure that out.
_
Von: Vyacheslav Kalinin [mailto:[EMAIL PROTECTED]
On 12/10/07, Keith Turner <[EMAIL PROTECTED]> wrote:
> We are running 8.1 on Windows 2003 server and have had a server crash
> over the weekend. A virus is suspected - we maintain an app server on
> someone else's network, though we do have anti-virus running, the
> symptoms were worrying - so we
SHARMILA JOTHIRAJAH wrote:
Hi,
Is it possible to implement postgres version upgrade using WAL files?
Currently the WAL file replication donot work between two different
postgres version. Is there a posiibility to implement this using WAL
files so that when I want to upgrade to the latest versio
Hi,
Is it possible to implement postgres version upgrade using WAL files?
Currently the WAL file replication donot work between two different postgres
version. Is there a posiibility to implement this using WAL files so that when
I want to upgrade to the latest version I can use these WAL?
Thank
> should do the trick without double select, or?
Indeed it seems to do so. The cost estimation is even about 10 times less
with the real application's queries.
I never really used group/having even though being aware of their existence.
I probably should do so more often.
On Dec 11, 2007, at 12:00 PM, Scott Marlowe wrote:
On Dec 11, 2007 11:41 AM, Leif B. Kristensen <[EMAIL PROTECTED]>
wrote:
It certainly isn't a crime. But it's a bit like thread hijacking
in the
sense that a well-formed inline posting is more likely to attract
intelligent replies. I don't
Stanislav,
SELECT
>t2.id,
>(SELECT COUNT(id) FROM t4 WHERE t2_id = t2.id AND value=10)
> AS t4_num
> FROM
>t2
> WHERE
>t2.active
>AND (
> (SELECT COUNT(id) FROM t4 WHERE t2_id = t2.id AND value=10) <= 3
>)
>
>
"Matt Magoffin" <[EMAIL PROTECTED]> writes:
> Hello, I'm trying to write a query to return an XML document like
>
>
>
> ...
>
Something like this:
regression=# select xmlelement(name root, xmlagg(x)) from
regression-# (select xmlelement(name range, xmlattributes(string4, count(*)
as
On Dec 11, 2007 11:41 AM, Leif B. Kristensen <[EMAIL PROTECTED]> wrote:
>
> It certainly isn't a crime. But it's a bit like thread hijacking in the
> sense that a well-formed inline posting is more likely to attract
> intelligent replies. I don't think that I'm the only one who tends to
> skip top
> People frequently think that because ORDER BY can refer to the
> output-column aliases, other clauses should be able to do it too,
> but this is not so.
Thank you very much for clearing that one up.
Now I have a follow-up question. Let's assume that I want not only to
evaluate a subquery for th
On Dec 11, 2007, at 9:40 AM, Tom Lane wrote:
Steve Atkins <[EMAIL PROTECTED]> writes:
In the business world it's common to top-post and not cut previous
content
- and often appropriate, as it tends to be a communication between a
smaller number of people, and the uncut content provides context
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 11 Dec 2007 17:37:27 +
Gregory Stark <[EMAIL PROTECTED]> wrote:
>
> "Gregory Williamson" <[EMAIL PROTECTED]> writes:
>
> > Confidentiality Notice: This e-mail message, including any
> > attachments, is for the sole use of the intended re
Vivek Khera <[EMAIL PROTECTED]> writes:
> I, along with at least Erik, was thinking that the constraint
> expression would be evaluated to determine whether to include the
> partition in the final plan. Based on Tom's description, it is not
> the case: the planner basically proves that the c
On Tuesday 11. December 2007, Andrew Sullivan wrote:
>I don't think top posting is always the crime it's made to be (and I
> get a little tired of lectures to others about it on these lists).
It certainly isn't a crime. But it's a bit like thread hijacking in the
sense that a well-formed inline
In response to "Gregory Williamson" <[EMAIL PROTECTED]>:
>
> -Original Message-
> From: [EMAIL PROTECTED] on behalf of Joshua D. Drake
> Sent: Tue 12/11/2007 9:43 AM
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Hijack!
>
> -BEGIN PGP SIGNED MESS
Steve Atkins <[EMAIL PROTECTED]> writes:
> In the business world it's common to top-post and not cut previous
> content
> - and often appropriate, as it tends to be a communication between a
> smaller number of people, and the uncut content provides context for
> future reference.
> Those who ra
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 11 Dec 2007 10:03:39 -0700
"Gregory Williamson" <[EMAIL PROTECTED]> wrote:
> >
> > However, I would also note that in "windows" world, it is very
> > common to top post. I am constantly retraining very smart, just
> > very ignorant customers.
"Gregory Williamson" <[EMAIL PROTECTED]> writes:
> Confidentiality Notice: This e-mail message, including any attachments, is for
> the sole use of the intended recipient(s) and may contain confidential and
> privileged information and must be protected in accordance with those
> provisions. Any
Mitchell Vincent wrote:
> On Jul 29, 2007 2:51 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>> Mitchell Vincent wrote:
>>> Ah, I see what you mean.
>>>
>>> I was hoping to be able to rebuild the MSI to not include the things I
>>> didn't need but that doesn't look like it's going to be the case..
Gregory Williamson wrote:
* Try to see the world from a perspective other that your own
(admittedly superior) one ! Not everyone is so advanced.
* Get a life -- how people post is _trivial_. *content* over *form* !
Beating dead horses is of no interest other than the inherent joy in
the thing.
1 - 100 of 146 matches
Mail list logo
