[sqlite] RE: Data Types

Mon, 26 Jul 2004 04:55:06 -0700

This seems to be the result of creating a table as:
 
CREATE TABLE temp AS SELECT * FROM another_table
 
Surely the datatypes of the original query (SELECT * FROM another_table) should be used for the new table temp?
 
Regards,
Steve

From: Drew, Stephen
Sent: Tuesday, July 20, 2004 5:25 PM
To: Drew, Stephen; '[EMAIL PROTECTED]'
Subject: RE: Data Types

Hello again,
 
Can anyone answer these simple questions for me?
  • Why is the SHOW_DATATYPES pragma not mentioned on the SQL syntax page under the PRAGMA keyword section?
  • Do I have to execute the pragma per transaction?
  • If not, why I am intermittently not getting the data types?
Thanks,
Steve
From: Drew, Stephen
Sent: Monday, July 19, 2004 7:09 PM
To: '[EMAIL PROTECTED]'
Subject: Data Types

Hi there,
 
I am using the PRAGMA command "SHOW_DATATYPES=on".  However, not all of my queries return the datatypes.  Has anyone else experienced this problem?
 
Regards,
Steve

Reply via email to