 | |
Determine length of bitfield
comp.databases.postgresql comp.databases.postgresql
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Determine length of bitfield -
06-12-2008
, 08:59 AM
#2
| |||
| |||
|
|
I'm currently trying to insert data into a table which contains a bit(32) field. However, the "32" bits should be kept variable, that means I do not want to code something that relies on the field length to be 32, it might well be 48 or 64. So what I'm trying to do is the following INSERT INTO mytable (bitfield) VALUES (CAST(0 AS bit(32))); This works. However, the bit(32) is explicit. What I'd like is something like INSERT INTO mytable (bitfield) VALUES (CAST(0 AS TYPEOF(bitfield))); How is that possible when using Postgres? |
What do you want to achieve, I mean, what is your goal?
Maybe there is a different way to do it.
Yours,
Laurenz Albe
#3
| |||
| |||
|
|
I'm currently trying to insert data into a table which contains a bit(32) field. However, the "32" bits should be kept variable, that means I do not want to code something that relies on the field length to be 32, it might well be 48 or 64. So what I'm trying to do is the following INSERT INTO mytable (bitfield) VALUES (CAST(0 AS bit(32))); This works. However, the bit(32) is explicit. What I'd like is something like INSERT INTO mytable (bitfield) VALUES (CAST(0 AS TYPEOF(bitfield))); How is that possible when using Postgres? |
What do you want to achieve, I mean, what is your goal?
Maybe there is a different way to do it.
Yours,
Laurenz Albe
#4
| |||
| |||
|
|
I'm currently trying to insert data into a table which contains a bit(32) field. However, the "32" bits should be kept variable, that means I do not want to code something that relies on the field length to be 32, it might well be 48 or 64. So what I'm trying to do is the following INSERT INTO mytable (bitfield) VALUES (CAST(0 AS bit(32))); This works. However, the bit(32) is explicit. What I'd like is something like INSERT INTO mytable (bitfield) VALUES (CAST(0 AS TYPEOF(bitfield))); How is that possible when using Postgres? |
What do you want to achieve, I mean, what is your goal?
Maybe there is a different way to do it.
Yours,
Laurenz Albe
#5
| |||
| |||
|
|
I'm currently trying to insert data into a table which contains a bit(32) field. However, the "32" bits should be kept variable, that means I do not want to code something that relies on the field length to be 32, it might well be 48 or 64. So what I'm trying to do is the following INSERT INTO mytable (bitfield) VALUES (CAST(0 AS bit(32))); This works. However, the bit(32) is explicit. What I'd like is something like INSERT INTO mytable (bitfield) VALUES (CAST(0 AS TYPEOF(bitfield))); How is that possible when using Postgres? |
What do you want to achieve, I mean, what is your goal?
Maybe there is a different way to do it.
Yours,
Laurenz Albe
#6
| |||
| |||
|
|
I'm currently trying to insert data into a table which contains a bit(32) field. However, the "32" bits should be kept variable, that means I do not want to code something that relies on the field length to be 32, it might well be 48 or 64. So what I'm trying to do is the following INSERT INTO mytable (bitfield) VALUES (CAST(0 AS bit(32))); This works. However, the bit(32) is explicit. What I'd like is something like INSERT INTO mytable (bitfield) VALUES (CAST(0 AS TYPEOF(bitfield))); How is that possible when using Postgres? |
What do you want to achieve, I mean, what is your goal?
Maybe there is a different way to do it.
Yours,
Laurenz Albe
#7
| |||
| |||
|
|
I'm currently trying to insert data into a table which contains a bit(32) field. However, the "32" bits should be kept variable, that means I do not want to code something that relies on the field length to be 32, it might well be 48 or 64. So what I'm trying to do is the following INSERT INTO mytable (bitfield) VALUES (CAST(0 AS bit(32))); This works. However, the bit(32) is explicit. What I'd like is something like INSERT INTO mytable (bitfield) VALUES (CAST(0 AS TYPEOF(bitfield))); How is that possible when using Postgres? |
What do you want to achieve, I mean, what is your goal?
Maybe there is a different way to do it.
Yours,
Laurenz Albe
#8
| |||
| |||
|
|
I'm currently trying to insert data into a table which contains a bit(32) field. However, the "32" bits should be kept variable, that means I do not want to code something that relies on the field length to be 32, it might well be 48 or 64. So what I'm trying to do is the following INSERT INTO mytable (bitfield) VALUES (CAST(0 AS bit(32))); This works. However, the bit(32) is explicit. What I'd like is something like INSERT INTO mytable (bitfield) VALUES (CAST(0 AS TYPEOF(bitfield))); How is that possible when using Postgres? |
What do you want to achieve, I mean, what is your goal?
Maybe there is a different way to do it.
Yours,
Laurenz Albe
#9
| |||
| |||
|
|
I'm currently trying to insert data into a table which contains a bit(32) field. However, the "32" bits should be kept variable, that means I do not want to code something that relies on the field length to be 32, it might well be 48 or 64. So what I'm trying to do is the following INSERT INTO mytable (bitfield) VALUES (CAST(0 AS bit(32))); This works. However, the bit(32) is explicit. What I'd like is something like INSERT INTO mytable (bitfield) VALUES (CAST(0 AS TYPEOF(bitfield))); How is that possible when using Postgres? |
What do you want to achieve, I mean, what is your goal?
Maybe there is a different way to do it.
Yours,
Laurenz Albe
#10
| |||
| |||
|
|
What do you want to achieve, I mean, what is your goal? Maybe there is a different way to do it. |
table structure is. This means if the table structure is bit(8) I want
to insert B'00000000', but if the table should be bit(4) I'd like to
insert B'0000' - all of this without having to rely on the exact length
or the need to check this in advance.
Regards,
Johannes
--
"Wer etwas kritisiert muss es noch lange nicht selber besser können. Es
reicht zu wissen, daß andere es besser können und andere es auch
besser machen um einen Vergleich zu bringen." - Wolfgang Gerber
in de.sci.electronics <47fa8447$0$11545$9b622d9e (AT) news (DOT) freenet.de>
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.