[EMAIL PROTECTED] wrote:
>
> Carolyn Lu Wong wrote:
> >
> > I need to write a trigger to create a new record in log table if it's a
> > new record or if column A and B changes. Can someone give me an example
> > how to do this.
> >
> > Are there any sites that gives trigger examples??
> >
> > Tha
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Can someone comment on this?
>>
>> I just noticed that postgres doesn't totally support
>> column aliases on UPDATE statements, for example
The SQL92 spec very clearly does not allow an alias on the target table:
13.10
::=
Can someone help me with the following?
1) Is there a command I can check which users are currently connecting
to a particular database? Is it possible to disconnect certain users who
are currently using the database? Can it also apply to connections to
the database via ODBC?
2) When doing datab
Carolyn Lu Wong wrote:
>
> I need to write a trigger to create a new record in log table if it's a
> new record or if column A and B changes. Can someone give me an example
> how to do this.
>
> Are there any sites that gives trigger examples??
>
> Thanks.
the fulltextindex in the contrib dir
I need to write a trigger to create a new record in log table if it's a
new record or if column A and B changes. Can someone give me an example
how to do this.
Are there any sites that gives trigger examples??
Thanks.
It seems to me that aliases on updates are something totally superflous.
Since updates always work on one table at a time, why bother especifying the
table each field comes from?
> Can someone comment on this?
>
> > Hi,
> >
> > I just noticed that postgres doesn't totally support
> > column alias
Can someone comment on this?
> Hi,
>
> I just noticed that postgres doesn't totally support
> column aliases on UPDATE statements, for example
>
> UPDATE EMPLOYEES SET
> OFFICE_PHONE = UU.OFFICE_PHONE,
> MOBILE_PHONE = UU.MOBILE_PHONE,
>
I have created a trigger when updating/inserting into a table, the row
is inserted into a log table. I get the following error when i tried to
update the table:
ERROR: Unable to locate type oid 0 in catalog
what does this mean?
