[GENERAL] can i use an array as a table (in the from clause)

2007-08-13 Thread Coarr, Matt
Is there some way that I can treat a two dimensional array as a table that can be referenced in the from clause? Thanks, Matt ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan

[GENERAL] any way to query for current connections to db?

2007-11-09 Thread Coarr, Matt
Hi, Is there any way to query the database to identify what the current connections are (connections, sessions, or whatever you want to call them)? This would be something similar to oracle's v$session view. Thanks, Matt