Hsin Lee [EMAIL PROTECTED] writes:
We would like to get your feedback about this aproach - are we on the
right track or is it a waste of time?
Impossible to tell, since you haven't said word one about what this
box is or what it can do. If it were plain storage hardware, why do
you need to
I'm porting some stored procedures from a MSSQL server, and thought
I'd use PL/pgSQL.
The original code is checking the insert with the line:
if (@@Error != 0)
How do I do the same thing in PL/pgSQL?
--
Turbo __ _ Debian GNU Unix _IS_ user friendly - it's just
^
I'm porting some stored procedures from a MSSQL server, and thought I'd
use PL/pgSQL.
The original code is checking the insert with the line:
if (@@Error != 0)
You might want to use something like:
SELECT INTO variable_name *
FROM table
WHERE field = some_value;
IF FOUND THEN
Hi.
Has anybody gop plpython to work on linux/pg7.1.2 ?
I built it as instructed in the README, but calling the first
plpython function (stupid() from the test suite) causes immediate
closedown.
there is nothing in the logs either ...
I tried it first with python2.1 and then python 1.5 with
* John Gray [EMAIL PROTECTED] wrote:
|
| OR, depending on what these fwbuilder objects involve, you can of
| course just store XML documents in fields of type text (especially if
| you use 7.1 which has TOAST, so you can store long documents). IT's
| not difficult to hook up a parser (I'm
Is there a way to debug a PL/pgSQL function? It's behaving very irradic!
I have two function, one that works and one that doesn't. The part that
don't work in func2 is 'SELECT INTO ... ...' and I can't figgure out
why it doesnt't work!
--
Turbo __ _ Debian GNU Unix _IS_ user
Hello
Consider two simple tables: AA, BB.
proba=# \d aa
Table aa
Attribute | Type | Modifier
---+-+--
id| bigint |
val | integer |
proba=# select * from aa;
id | val
+-
1 | 1
2 | 2
2 | 2
3 | 3
3 | 3
3 |
Vladimir V. Zolotych [EMAIL PROTECTED] writes:
proba=# insert into bb select id,val,count(val) from aa group by id,val;
pqReadData() -- backend closed the channel unexpectedly.
Try 7.1. Prior releases tend to have problems with implicit datatype
conversions in INSERT ... SELECT.
Hello all,
Is anybody trying to solve the 8191 bytes query limit from libpq
windows port ???
We've discussed this topic on Large queries - again thread and it
seems like nobody got interested on fixing it.
All Windows applications that rely on libpq are broken because of
How many rows are returned by the query in reality ?
Does the table *table1* have an index on the column *var1*
in your centura sqlbase ?
... and did you do a vacuum analyze? What is the schema? What is the
query? What is the result of explain for that query?
All of these things are relevant
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Jean-Michel POURE) wrote:
Hello friends,
What is the best way to parse and store an XML document in PostgreSQL? I
would like to store fwbuilder (http://www.fwbuilder.org) objects in
PostgreSQL.
I think the best way depends on what you're
Joel == Joel Burton [EMAIL PROTECTED] writes:
Joel On 25 Jul 2001, Turbo Fredriksson wrote:
Is there a way to debug a PL/pgSQL function? It's behaving very
irradic!
Joel It's crude, but you can output debugging statements w/ RAISE
Joel NOTICE or catch flawed assumptions
On 25 Jul 2001, Turbo Fredriksson wrote:
Is there a way to debug a PL/pgSQL function? It's behaving very irradic!
It's crude, but you can output debugging statements w/ RAISE NOTICE
or catch flawed assumptions by RAISE EXCEPTION.
--
Joel Burton [EMAIL PROTECTED]
Director of Information
13 matches
Mail list logo