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

Reply via email to