On Nov 11, 2011, at 8:38, the6campbells wrote:
> consider the following
>
> create table TARRBINT ( RNUM integer not null , CARRBINT bigint array[5] ) ;
>
> Can someone clarify why Postgres does not like examples 2, 6 and 7
An array must have a base type; an empty array has nothing with whi
consider the following
create table TARRBINT ( RNUM integer not null , CARRBINT bigint array[5] )
;
Can someone clarify why Postgres does not like examples 2, 6 and 7
1.insert into TARRBINT(RNUM, CARRBINT) values ( 0, null);
2.insert into TARRBINT(RNUM, CARRBINT) values ( 0, ARRAY[]);
3.insert
Manu T, 07.11.2011 08:18:
I am using this query in the procedure and i error is throwing as mentioned
below.and i want to convert the same oracle query into Postgresql.
ERROR-->
*ERROR: syntax error at or near "OVER"
LINE 1: ...heme_id,d.value, d.dr_cr_flg , d.rule_id , RANK() OVER (part...
^
