We're using postgresql 9.1, and we've got a table that looks like this:
testdb=# \d item
Table public.item
Column | Type | Modifiers
---+--+---
sig | bigint | not null
type | smallint |
data | text |
Indexes:
item_pkey PRIMARY KEY, btree (sig)
And
On 11-11-02 08:49 AM, Merlin Moncure wrote:
On Wed, Nov 2, 2011 at 6:22 AM, Chris Dumoulinch...@blaze.io wrote:
We're using postgresql 9.1, and we've got a table that looks like this:
testdb=# \d item
Table public.item
Column | Type | Modifiers
---+--+---
sig |
On 11-11-02 09:13 AM, Martijn van Oosterhout wrote:
On Wed, Nov 02, 2011 at 07:22:09AM -0400, Chris Dumoulin wrote:
And we're doing an insert like this:
INSERT INTO Item (Sig, Type, Data) SELECT $1,$2,$3 WHERE NOT EXISTS
( SELECT NULL FROM Item WHERE Sig=$4)
In this case $1 and $4 should
We're using postgresql 9.1, and we've got a table that looks like this:
testdb=# \d item
Table public.item
Column | Type | Modifiers
---+--+---
sig | bigint | not null
type | smallint |
data | text |
Indexes:
item_pkey PRIMARY KEY, btree (sig)
And