Displaying 1 result from an estimated 1 matches for "artnr_id".
Did you mean:
actor_id
2012 Aug 24
1
Regular expressions: stuck again...
...he task to convert a lot of queries to postgreSQL.
What I want to do is make a function which takes the MS Access query as an
argument and returns the pgSQL version.
So:
SELECT [public_tblFiche].[Fichenr], [public_tblArtnr].[Artnr] FROM
[public_tblFiche], [public_tblArtnr] WHERE [public_tblFiche].[Artnr_ID] =
[public_tblArtnr].[Artnr_ID];
or
SELECT public_tblFiche.Fichenr, public_tblArtnr.Artnr FROM public_tblFiche,
public_tblArtnr WHERE public_tblFiche.Artnr_ID = public_tblArtnr.Artnr_ID;
Should become:
SELECT \"public\".\"tblFiche\".\"Fichenr\",
\"public\"...