El 15/05/15 a las 12:26, Michael Van Canneyt escibió:
On Fri, 15 May 2015, "Leonardo M. Ramé" wrote:
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?.
I would think
insert into documents(document_name, document_type) values(:name,
(:type)::doc_type )';
?
Michael.
Yes, that was the solution.
Leonardo.
--
_______________________________________________
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus