Thread: data types

I posted a question on JDBC yesterday because I was having data typing
problmes. But it is not a JDBC problem...

I am trying to populate an array

CREATE TABLE festival (
festivalID INTEGER PRIMARY KEY,
filmID INTEGER[] REFERENCES films
);

festivalID = 1998 etc.
filmID = {212, 104, xxx}

any attempt to insert data gives

"Unable to identify an operator '=' for types 'int4' and '_int4'"

Where did the _int4 type come from? How do I work around this?

TIA

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

On Wed, Aug 08, 2001 at 03:15:33PM +0200, Tony Grant wrote:
> "Unable to identify an operator '=' for types 'int4' and '_int4'"
>
> Where did the _int4 type come from? How do I work around this?

IIRC the underscore is the internal name for ARRAY OF.

I don't think your references statement is valid.
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> It would be nice if someone came up with a certification system that
> actually separated those who can barely regurgitate what they crammed over
> the last few weeks from those who command secret ninja networking powers.

On 08 Aug 2001 23:42:47 +1000, Martijn van Oosterhout wrote:

> > "Unable to identify an operator '=' for types 'int4' and '_int4'"
> >
> > Where did the _int4 type come from? How do I work around this?
>
> IIRC the underscore is the internal name for ARRAY OF.
>
> I don't think your references statement is valid.

Thanks that did it

Tony

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html