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
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
[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,
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
