guesty |
Beginner |

 |
|
Joined: May 17, 2004 |
Posts: 3 |
|
|
|
 |
 |
 |
|
Hi,
how to make union work if one column from source table has got text[] type.
for ex.:
Code: |
CREATE TABLE first (
name integer,
story text[]
);
CREATE TABLE second (
what integer,
where text
);
|
query is smth like this:select * from first where name=$my_input
in url: my_input=1 and 1=0 union select 0,....and what to put here. if I put another 0 then I get:
text[] and integer cannot be matched |
|