Dear users,
I have this problem
I have a table where there are 20 columns named
vinc1, vinc2, vinc3, vinc4, etc
the values contained into each column are simply 1 or 0 (each column is
dichotomic)
1 means presence
0 means absence
I would obtain a column (new_column) containg the name of the
Just a thought,
Could you achieve that same result using the binary representation of an
integer?
Regards,
Richard
--- ivan marchesini <[EMAIL PROTECTED]> wrote:
> Dear users,
> I have this problem
>
> I have a table where there are 20 columns named
> vinc1, vinc2, vinc3, vinc4, etc
>
Sorry, I'm not able to understand how I can use this solution!!!
can you better explain me your suggestion???
Thanks very much
Il giorno gio, 13/04/2006 alle 06.51 -0700, Richard Broersma Jr ha
scritto:
> Just a thought,
>
> Could you achieve that same result using the binary representation of
Hi
If I can not do insert/update action with on select rule, how can I
execute some procedure or any sql statement on select event?
WBR
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an i
I have a table where there are 20 columns named
vinc1, vinc2, vinc3, vinc4, etc
the values contained into each column are simply 1 or 0 (each column is
dichotomic)
1 means presence
0 means absence
I would obtain a column (new_column) containg the name of the columns,
comma separated, where
am 13.04.2006, um 18:46:02 +0300 mailte Sergey Levchenko folgendes:
> Hi
>
> If I can not do insert/update action with on select rule, how can I
> execute some procedure or any sql statement on select event?
With a TRIGGER.
HTH, Andreas
--
Andreas Kretschmer(Kontakt: siehe Header)
Heynitz
Hi,
I have, what I hope to be, a simple question about plpgsql.
I have a trigger on a table right now that updates a count everytime
that a new record is entered into a database (or removed).
What I'd also like to do is have it create a new row in a different
table using the automatically assign
