-
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 ( # ).
For example:
[quote] CREATE FUNCTION GetSmallest1(:A integer, :B Integer)
RETURNS Integer
AS
BEGIN
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]call psp_indexes('DEMODATA','Class')[/quote]
returns:
[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?