What version of PSQL are you using?
What version of the Entity Framework?
What version of the ADO.NET provider are you using?
What is your table definition in the database?
There are samples in the documentation. Did you look at the docs?
The String Scalar functions have functions that will work for you whether you are looking for the length of the data or the length of the column.
I don't have v10 to test with. I believe the statement separator has been there for a lot longer than v10.
You can create your functions using the CREATE FUNCTION SQL statement like Jay suggested. You would separate each CREATE FUNCTION statement with a pound symbol ( # ).
[quote] CREATE FUNCTION GetSmallest1(:A integer, :B Integer)
DECLARE :smallest INTEGER
IF (:A < :B ) THEN
SET :smallest ...
DTO2.DLL was included with the PSQL install package. If you don't have it, you might have a version that didn't support it.
With v10, you can use the System Stored Procedures and the psp_indexes procedure specifically to get this information. For example:
[quote]"TABLE_QUALIFIER", "TABLE_OWNER", "TABLE_NAME", "INDEX_NAME", ...
At this point, without your data and a testcase, any ideas would be speculation. If this is a problem you need solved, you should open a ticket (http://pervasivedb.com/support/Pages/Default.aspx). If it is a defect, you ticket will be refunded.
In PCC, are you executing to Grid or Text?
Have you tried any other tools like ODBC Test?
What is your exact query?
A few questions:
- What tool are you using to execute the query?
- What is your query? What kind of optimization have you done on the query?
- Have you tried V11 SP3?
- How many records are in the table? If you remove all restrictions, can you get all the records?