Hello,
In this case, I don't have to alter the definition to the extent of
changing the data type, but rather to change the length of a varchar
field/column. I found the following from a past posting to one of the
PostgreSQL user lists that does work, but I'd like something a bit more
elegant and
[EMAIL PROTECTED] wrote:
> Hello,
>
> The +4 is for the overhead of a varchar field.
>
> Using ALTER TABLE ALTER TYPE VARCHAR() to
> change the size requires scanning the entire table. For large tables,
> this will be much slower than the pg_attribute query. Both will get
> the job done.
>
Th
Hello,
Well, the subject line pretty much says it all. If any clarification
is needed, what I want to do is as follows:
SELECT * FROM table WHERE thisfield = 'some text';
How would I rewrite this query to search through the table looking at
the text in the column "thisfield" for the string "som
Hello everyone,
If anyone here has, would you please share with me how to create the
connections, perform a query and then iterate over its results? I've
been reading through the online documentation for this library at
http://thaiopensource.org/devprojects/libpqxx/doc/2.6.8/html/Reference/
and I
