Hi, I need to insert a value into a custom type column in a PostgreSql database.

The type was created using this:

create type doc_type as enum('pdf', 'rtf', 'html', 'doc', 'docx', 'xls',
'xlsx', 'txt');

To insert a field into a table with one column of that type, I use:

var
   lQuery: TSqlQuery;
begin
   ...
   lQuery.Sql.Text := 'insert into documents(document_name,
document_type) values(:name, :type)';
   lQuery.ParamByName('type').AsString := 'txt';
   ...

I get "Primary Error: column "document_type" is of type doc_type but expression is of type text". How can I cast this?.

Regards,

I would think
insert into documents(document_name, document_type) values(:name, (:type)::doc_type )'; ?

Michael.

El 15/05/15 a las 12:26, Michael Van Canneyt escibi?:

Yes, that was the solution.

Leonardo.