Hello,
I use postgres 8.1 and trie to run jboss over sequoia-ha
(http://sequoia.continuent.org/HomePage). But i have an problem with sequences.
Sequoia claims to support for good reasons and db-independece only
"sql-standard(s)". Therefore they DON'T support the postgres-specific "select
next
Ray,
There's a good introductory article on Sitepoint for doing this kind of thing:
http://www.sitepoint.com/article/hierarchical-data-database
The "Modified Preorder Tree Traversal" is quite a nice method that I
would expect to be a magnitude faster than recursive joins, although
does have som
Hi, Tom,
Tom Lane wrote:
>>As I said the leftovers are likely to be caused by hard kills and
>>backend crashes, so I would not go into deeper analysis, but maybe the
>>finding and possibly removing of such leftovers should be half-automated
>>to assist server admins.
>
> It's been discussed. Pe
Hi, Bruce,
Bruce Momjian wrote:
> I have work someone did in the past. I just need to be updated to deal
> with tablespaces.
>
> ftp://candle.pha.pa.us/pub/postgresql/mypatches/checkfile.*
>
> Let me know if you want details.
It looks nice, but I would not like automatic deletion (or on
any one can help me how to get multiple rows in postgresql
using arrays in functions
Thanks & Regards
Penchal reddy | Software Engineer
Infinite Computer Solutions | Exciting Times…Infinite Possibilities...
SEI-CMMI level 5 | ISO 9001:2000
IT SERVICES |
BPO
On Thu, Apr 27, 2006 at 04:57:26PM +0530, Penchalaiah P. wrote:
> any one can help me how to get multiple rows in postgresql using arrays
> in functions
What is it you are trying to do?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Information security isn't a technological problem. It's an econo
Markus Schaber <[EMAIL PROTECTED]> writes:
> Bruce Momjian wrote:
>> I have work someone did in the past. I just need to be updated to deal
>> with tablespaces.
>>
>> ftp://candle.pha.pa.us/pub/postgresql/mypatches/checkfile.*
> It looks nice, but I would not like automatic deletion (or only opt
Comming back after SELECTing into usertypes, is there a nice way to
insert data into table from usertype, in a nice way?
For instance, I have table like this:
CREATE TABLE tblA (
id int4,
key varchar,
value varchar
)
Then, in my function, I do this:
CREATE FUNCTION testI
Penchalaiah P. wrote:
any one can help me how to get multiple rows in postgresql using arrays
in functions
What exactly do you want to do? Are you trying to match a column against
multiple values in an array, or what? What difference is the function
making to your problem?
--
Richard Hux
Mario Splivalo <[EMAIL PROTECTED]> writes:
> Comming back after SELECTing into usertypes, is there a nice way to
> insert data into table from usertype, in a nice way?
Try
insert into tblA values (insert_tblA.*);
This works in CVS HEAD at least, not sure how far back.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
Sorry for the late response, but I'm quite busy and I wanted
to test this before replying...
Bruce Momjian schrieb:
> Tom Lane wrote:
>> Andreas Haumer <[EMAIL PROTECTED]> writes:
>>> How can I get the functionality of an "deferred AFTER trigger"
I have a table that I created that implements a linked list. I am not an
expert SQL developer and was wondering if there are known ways to traverse
the linked lists. Any information that can point me in the direction to
figure this out would be appreciated. The table contains many linked lists
12 matches
Mail list logo
