You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
when use in the From Clause,the TBLE_project get error:
postgres=# select * from samp3_project(samp3_get());
NOTICE: IMCS command: project
ERROR: function return row and query-specified return row do not match
DETAIL: Returned type bigint at ordinal position 1, but query expects timestamp without time zone.
while run the function as select list, it is ok:
postgres=# select samp3_project(samp3_get());
NOTICE: IMCS command: project
when use in the From Clause,the TBLE_project get error:
postgres=# select * from samp3_project(samp3_get());
NOTICE: IMCS command: project
ERROR: function return row and query-specified return row do not match
DETAIL: Returned type bigint at ordinal position 1, but query expects timestamp without time zone.
while run the function as select list, it is ok:
postgres=# select samp3_project(samp3_get());
NOTICE: IMCS command: project
samp3_project
(631950263,2191a6ae264f1058fb01a0084a73b509,"2014-02-23 00:00:07")
(294969415,dc8028c36369b682d695c360f19ccf17,"2014-02-23 00:00:07")
(778660501,31eae0cfda948b3c3852c5cbf2e63659,"2014-02-23 00:00:07")
...
this also OK:
postgres=# select samp3_project(t) from samp3_get() as t;
NOTICE: IMCS command: project
samp3_project
(631950263,2191a6ae264f1058fb01a0084a73b509,"2014-02-23 00:00:07")
(294969415,dc8028c36369b682d695c360f19ccf17,"2014-02-23 00:00:07")
(778660501,31eae0cfda948b3c3852c5cbf2e63659,"2014-02-23 00:00:07")
(667438543,f2dbd4d6a989ba4f539a661a4212458f,"2014-02-23 00:00:07")
...
The text was updated successfully, but these errors were encountered: