Mark Forums Read

Possible: using ordinal number instead of column name

Go Back

comp.databases.postgresql comp.databases.postgresql

Reply

Page 2 of 2

2

#11

Old

Laurenz Albe

Posts: n/a

Re: Possible: using ordinal number instead of column name - 04-28-2008 , 02:40 AM

Anton Huber <hoover (AT) gmx (DOT) at> wrote:

Quote:

to have it easier using one trigger doing similar things on different
tables I was wondering if it would be possible to use the ordinal # of
a column instead of using the column name.

This kind of thing will not be possible with PL/pgSQL, as far as I know.

You could write your trigger in PL/Perl
http://www.postgresql.org/docs/curre...-triggers.html

You might be able to do more there.

Yours,
Laurenz Albe

Reply With Quote

#12

Old

Laurenz Albe

Posts: n/a

Re: Possible: using ordinal number instead of column name - 04-28-2008 , 02:40 AM

Anton Huber <hoover (AT) gmx (DOT) at> wrote:

Quote:

to have it easier using one trigger doing similar things on different
tables I was wondering if it would be possible to use the ordinal # of
a column instead of using the column name.

This kind of thing will not be possible with PL/pgSQL, as far as I know.

You could write your trigger in PL/Perl
http://www.postgresql.org/docs/curre...-triggers.html

You might be able to do more there.

Yours,
Laurenz Albe

Reply With Quote

#13

Old

Laurenz Albe

Posts: n/a

Re: Possible: using ordinal number instead of column name - 04-28-2008 , 02:40 AM

Anton Huber <hoover (AT) gmx (DOT) at> wrote:

Quote:

to have it easier using one trigger doing similar things on different
tables I was wondering if it would be possible to use the ordinal # of
a column instead of using the column name.

This kind of thing will not be possible with PL/pgSQL, as far as I know.

You could write your trigger in PL/Perl
http://www.postgresql.org/docs/curre...-triggers.html

You might be able to do more there.

Yours,
Laurenz Albe

Reply With Quote

#14

Old

Laurenz Albe

Posts: n/a

Re: Possible: using ordinal number instead of column name - 04-28-2008 , 02:40 AM

Anton Huber <hoover (AT) gmx (DOT) at> wrote:

Quote:

to have it easier using one trigger doing similar things on different
tables I was wondering if it would be possible to use the ordinal # of
a column instead of using the column name.

This kind of thing will not be possible with PL/pgSQL, as far as I know.

You could write your trigger in PL/Perl
http://www.postgresql.org/docs/curre...-triggers.html

You might be able to do more there.

Yours,
Laurenz Albe

Reply With Quote

#15

Old

Laurenz Albe

Posts: n/a

Re: Possible: using ordinal number instead of column name - 04-28-2008 , 02:40 AM

Anton Huber <hoover (AT) gmx (DOT) at> wrote:

Quote:

to have it easier using one trigger doing similar things on different
tables I was wondering if it would be possible to use the ordinal # of
a column instead of using the column name.

This kind of thing will not be possible with PL/pgSQL, as far as I know.

You could write your trigger in PL/Perl
http://www.postgresql.org/docs/curre...-triggers.html

You might be able to do more there.

Yours,
Laurenz Albe

Reply With Quote

#16

Old

Laurenz Albe

Posts: n/a

Re: Possible: using ordinal number instead of column name - 04-28-2008 , 02:40 AM

Anton Huber <hoover (AT) gmx (DOT) at> wrote:

Quote:

to have it easier using one trigger doing similar things on different
tables I was wondering if it would be possible to use the ordinal # of
a column instead of using the column name.

This kind of thing will not be possible with PL/pgSQL, as far as I know.

You could write your trigger in PL/Perl
http://www.postgresql.org/docs/curre...-triggers.html

You might be able to do more there.

Yours,
Laurenz Albe

Reply With Quote

#17

Old

Laurenz Albe

Posts: n/a

Re: Possible: using ordinal number instead of column name - 04-28-2008 , 02:40 AM

Anton Huber <hoover (AT) gmx (DOT) at> wrote:

Quote:

to have it easier using one trigger doing similar things on different
tables I was wondering if it would be possible to use the ordinal # of
a column instead of using the column name.

This kind of thing will not be possible with PL/pgSQL, as far as I know.

You could write your trigger in PL/Perl
http://www.postgresql.org/docs/curre...-triggers.html

You might be able to do more there.

Yours,
Laurenz Albe

Reply With Quote

Reply

Page 2 of 2

2

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.