3 SQL STANDARD REQUIRES LENGTH ON VARCHAR
source | link

Maybe you just need to cast it.

 SELECT CAST( 'Text' as CHARACTER VARYING(99999) ) as FIELD FROM TABLE;

or using an alternative pg-specific casting syntax.

 SELECT 'Text'::varchar as FIELD FROM TABLE;

If you select a string constant and don't cast it to something it has type unknown. but I'm guessing your connection library converts this to the preferred postgres string type 'text'

Maybe you just need to cast it.

 SELECT CAST( 'Text' as CHARACTER VARYING) as FIELD FROM TABLE;

or using an alternative pg-specific casting syntax.

 SELECT 'Text'::varchar as FIELD FROM TABLE;

If you select a string constant and don't cast it to something it has type unknown. but I'm guessing your connection library converts this to the preferred postgres string type 'text'

Maybe you just need to cast it.

 SELECT CAST( 'Text' as CHARACTER VARYING(99999) ) as FIELD FROM TABLE;

or using an alternative pg-specific casting syntax.

 SELECT 'Text'::varchar as FIELD FROM TABLE;

If you select a string constant and don't cast it to something it has type unknown. but I'm guessing your connection library converts this to the preferred postgres string type 'text'

2 added 190 characters in body
source | link

Maybe you just need to cast it.

 SELECT CAST( 'Text' as CHARACTER VARYING) as FIELD FROM TABLE;

or using an alternative pg-specific casting syntax.

 SELECT 'Text'::varchar as FIELD FROM TABLE;

If you select a string constant and don't cast it to something it has type unknown. but I'm guessing your connection library converts this to the preferred postgres string type 'text'

Maybe you just need to cast it.

 SELECT CAST( 'Text' as CHARACTER VARYING) as FIELD FROM TABLE;

or using an alternative pg-specific casting syntax.

 SELECT 'Text'::varchar as FIELD FROM TABLE;

Maybe you just need to cast it.

 SELECT CAST( 'Text' as CHARACTER VARYING) as FIELD FROM TABLE;

or using an alternative pg-specific casting syntax.

 SELECT 'Text'::varchar as FIELD FROM TABLE;

If you select a string constant and don't cast it to something it has type unknown. but I'm guessing your connection library converts this to the preferred postgres string type 'text'

1
source | link

Maybe you just need to cast it.

 SELECT CAST( 'Text' as CHARACTER VARYING) as FIELD FROM TABLE;

or using an alternative pg-specific casting syntax.

 SELECT 'Text'::varchar as FIELD FROM TABLE;