Re: [Lazarus] Inserting enum type into Postgresql

2015-05-15 Thread Michael Van Canneyt
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

Re: [Lazarus] Inserting enum type into Postgresql

2015-05-15 Thread Leonardo M. Ramé
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',

[Lazarus] Inserting enum type into Postgresql

2015-05-15 Thread Leonardo M. Ramé
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: