Function VS. Embedded SQL

[raisin96]

Hi,

Which is better using functions to execute SQL statements or Embedded SQL...??? I'm currently doing Embedded SQL in C in an AIX environment.

Functions e.g.

PreparedStatement ps = con.prepareStatement("SELECT img FROM images WHERE imgname=?"
ps.setString(1, "myimage.gif"
ResultSet rs = ps.executeQuery();

or

Embedded SQL e.g. "EXEC SQL SELECT img FROM images
WHERE imgname=......"

Thanks.

 

[boaconstrictor]

I would stay on using embedded SQL, becaus it is not proprietary to PostgreSQL. With embedded SQL you can change the database much easier, because it is a standard which is provided on several databases.
In the case of changing a db you just precompile your .pgc file with the new db and thats it.

kind regards boaconstrictor

 

[raisin96]

Thanks boaconstrictor.

best regards,

raisin96