The table definition:
CREATE TABLE isi.isi_l1_publication
(
article_id character varying(15),
journal_id character varying(7),
volume character varying(10),
issue character varying(10),
publication_year character varying(4),
publication_date character varying(20),
id bigint NOT NULL
Sorry for waisting your time. I just now saw the missing period between A
and publication_year which is causing the problem and explains the
'strange' result.
Regards
Johann
On 3 October 2013 10:08, Johann Spies johann.sp...@gmail.com wrote:
The table definition:
CREATE TABLE
Johann Spies johann.sp...@gmail.com wrote:
SELECT A.article_id, A publication_year
I have seen it once before and could not figured out what is causing it.
The point is the missing point between A and publication_year ;-)
Andreas
--
Really, I'm not out to destroy Microsoft. That will
Johann Spies wrote:
SELECT A.article_id, A publication_year
You are missing a . between in what you think is the second
column (after the A).
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription: