https://bugs.documentfoundation.org/show_bug.cgi?id=124530
Robert Großkopf <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |WORKSFORME
Status|NEW |RESOLVED
--- Comment #7 from Robert Großkopf <[email protected]> ---
Problem seems to be PostgreSQL doesn't set the datatype the right way.
If I change the query to
4. Create a query like
SELECT "ID", "PathName", "PicName", CONCAT( '/home/yourname/', "PicName" ) AS
"PicPathName" FROM "public"."PG_LOconn"
tO
SELECT "ID", "PathName", "PicName", CAST(CONCAT( '/home/yourname/', "PicName" )
AS VARCHAR(100)) AS "PicPathName" FROM "public"."PG_LOconn"
it will work.
So I will close this bug as WORKSFORME.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs