Zeoslib Portal

Hello. We have a problem: PostgreSQL + Zeos + Delphi XE2... Consider this: DB part: CREATE DATABASE test WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE = pg_default LC_COLLATE = 'Lithuanian_Lithuania.1257' LC_CTYPE = 'Lithuanian_Lithuania.1257' CONNECTION LIMIT = -1; CREATE TABLE sutartis ( st_i...

Ahh, use char instead of varchar.

Hello. I have this SQL function in postgresql-9.3.2-1-windows-x64: CREATE OR REPLACE FUNCTION fnk_create_table(prm_name varchar, prm_surname varchar) RETURNS TABLE(clm_name varchar(3), clm_surname varchar(6)) AS $BODY$ BEGIN RETURN QUERY select CAST(prm_name AS varchar(3)) as clm_name, CAST(prm_surn...