Thank you for your suggestion which solved the problem. Much better
solution that what I was trying to accomplish. Much smaller table to query
since it only has one entry per user.
Clifford
On Wed, Dec 28, 2016 at 8:12 PM, Adrian Klaver
wrote:
> On 12/28/2016 07:06 PM, Clifford Snow wrote:
>
>>
On 12/28/2016 07:06 PM, Clifford Snow wrote:
I'm trying to write a trigger (my first) to update another table if the
user_id is new. But I'm getting a index exception that the user_id
What is the actual error message?
already exists. I'm picking up data from another feed which gives
provides
I'm trying to write a trigger (my first) to update another table if the
user_id is new. But I'm getting a index exception that the user_id already
exists. I'm picking up data from another feed which gives provides me with
changes to the main database.
what I have is
CREATE OR REPLACE FUNCTION add
Michael Satterwhite writes:
> On Monday, December 27, 2010 12:58:40 pm Guillaume Lelarge wrote:
>> Le 27/12/2010 18:57, Michael Satterwhite a écrit :
>>> I'm obviously missing something ... and probably something obvious. Why
>>> is date2 still null?
>>
>> I'm not sure it'll help you. I copy/past
Le 27/12/2010 22:16, Michael Satterwhite a écrit :
> On Monday, December 27, 2010 12:58:40 pm Guillaume Lelarge wrote:
>> Le 27/12/2010 18:57, Michael Satterwhite a écrit :
>>> I'm new to PostgreSQL, but have worked with other databases. I'm trying
>>> to write a trigger to default a timestamp colu
Michael,
I'm new to PostgreSQL, but have worked with other databases. I'm trying
to write a trigger to default a timestamp column to a fixed interval
before another. The test setup is as follows:
Try this pg_dump of a working example:
CREATE FUNCTION t_listing_startdate() RETURNS trigger
On Mon, Dec 27, 2010 at 1:14 PM, Michael Satterwhite
wrote:
> I've *GOT* to be missing something in this post. You start by quoting the
> "Create Trigger" that attaches the trigger to the table. Then you tell me that
> I've got to do what you showed that I did.
Oops, your right, I miss-read you
On Mon, Dec 27, 2010 at 9:57 AM, Michael Satterwhite
wrote:
> CREATE TRIGGER t_listing_startdate before insert or update on test
> for each row execute procedure t_listing_startdate();
Now that you've created a trigger function, you need to attached to your table:
http://www.postgresql.o
Le 27/12/2010 18:57, Michael Satterwhite a écrit :
> I'm new to PostgreSQL, but have worked with other databases. I'm trying to
> write a trigger to default a timestamp column to a fixed interval before
> another. The test setup is as follows:
>
> create table test
> ( date1 timestamp,
>
Michael,
I'm new to PostgreSQL, but have worked with other databases. I'm trying to
write a trigger to default a timestamp column to a fixed interval before
another. The test setup is as follows:
create table test
( date1 timestamp,
date2 timestamp
);
create or replace function t
Maybe I've missed it but can someone plese help me
with this?
Brgds and thanks in advance,
--- Dino Vliet <[EMAIL PROTECTED]> wrote:
> Hi folks,
> I'm new to PostgreSQL and am busy tring to work with
> it. Of pl/pgsql I know even less and that's the part
> I
> have a question on right now. I hav
Hi folks,
I'm new to PostgreSQL and am busy tring to work with
it. Of pl/pgsql I know even less and that's the part I
have a question on right now. I have this nice example
to get me started with
pl/pgsql...
I have a table with the schedule of a service my sport
team wants to offer:
Table Sch
12 matches
Mail list logo