[SQL] Data type conversion

2003-10-03 Thread Jan Pips
How to convert the interval type into integer, float or any "countable" data
type at the time of table creation using
select ... into?

Pips



---(end of broadcast)---
TIP 8: explain analyze is your friend


[SQL] Field list from table

2004-02-29 Thread Jan Pips
How can I, using SELECT, get the full list of fields from a given table?

Pips



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly