Re: default values
От | Felipe Schnack |
---|---|
Тема | Re: default values |
Дата | |
Msg-id | 1037791059.8876.186.camel@desenv1.ritterdosreis.br обсуждение исходный текст |
Ответ на | Re: default values (Dave Cramer <Dave@micro-automation.net>) |
Список | pgsql-jdbc |
That's the idea I suggested a week ago... On Tue, 2002-11-19 at 23:17, Dave Cramer wrote: > Well, the only way this is going to work is if you cast it into a > postgres resultset. > > I don't have any particular objection to this extension. > > Dave > On Tue, 2002-11-19 at 18:44, Stuart Robinson wrote: > > I think Felipe has a point here. I don't see any good reason why the driver's > > methods can't be a SUPERSET of those specified in the JDBC standard. As long > > as there's nothing forcing you to use the non-standard methods, it should be > > fine. So, for those who wish to stick to the standard for portability, there > > is predictable behavior; and for those who want some of the extra goodies > > provided by Postgres, there are options. > > > > -Stuart > > > > Quoting Felipe Schnack <felipes@ritterdosreis.br>: > > > > > So why setUseServerSidePrepare() was implemented? This is not potable, > > > not standard, not anything. > > > > > > On Mon, 2002-11-18 at 22:48, Barry Lind wrote: > > > > > > > > > > > > Felipe Schnack wrote: > > > > > > > > > > 2- This feature is avaliable in pgsql. Why not implement it? > > > > > > > > > Since default column capability isn't part of the jdbc standard yet (but > > > > since it is part of the SQL standard, I would expect it to be added > > > > someday to the jdbc spec), adding support for it would require the user > > > > to write non-portable jdbc code. Since there is a portable way to > > > > accomplish the same thing (i.e. not include the column in the insert), I > > > > don't see a compelling reason to add this functionality. > > > > > > > > thanks, > > > > --Barry > > > > > > > > > > > > > > > > > On Mon, 2002-11-18 at 17:16, Stuart Robinson wrote: > > > > > > > > > >>Hi, Felipe. > > > > >> > > > > >>I'm been trying to follow the discussion about default values and I'm a > > > little > > > > >>confused. I think David's reply is sensible. Unless I'm missing > > > something, I > > > > >>don't think there's an issue for inserts. All you have to do is not > > > specify the > > > > >>default column in the insert and it will automatically get the default > > > value. I > > > > >>think the issue only arises when you do updates, if you want to revert to > > > the > > > > >>default for a column that has been changed since it was originally > > > inserted. > > > > >> > > > > >>Ate mais, > > > > >>Stuart > > > > >> > > > > >>Quoting David Wall <David.Wall@Yozons.com>: > > > > >> > > > > >> > > > > >>>Why not simply remove varcharfield2 from the INSERT statement and let > > > the > > > > >>>database insert that value with the default value? Isn't the purpose of > > > a > > > > >>>default value to have the DB put that value in when none is specified? > > > > >> > > > > >>-- > > > > >>Stuart Robinson <stuart@zapata.org> > > > > >> > > > > >> > > > > >>------------------------------------------------- > > > > >>This mail sent through IMP: http://horde.org/imp/ > > > > > > > > > > > > > > > > > > > > -- > > > > > > Felipe Schnack > > > Analista de Sistemas > > > felipes@ritterdosreis.br > > > Cel.: (51)91287530 > > > Linux Counter #281893 > > > > > > Faculdade Ritter dos Reis > > > www.ritterdosreis.br > > > felipes@ritterdosreis.br > > > Fone/Fax.: (51)32303328 > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 2: you can get off all lists at once with the unregister command > > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > > > > > > -- > > Stuart Robinson <stuart@zapata.org> > > > > > > ------------------------------------------------- > > This mail sent through IMP: http://horde.org/imp/ > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- > Dave Cramer <Dave@micro-automation.net> > -- Felipe Schnack Analista de Sistemas felipes@ritterdosreis.br Cel.: (51)91287530 Linux Counter #281893 Faculdade Ritter dos Reis www.ritterdosreis.br felipes@ritterdosreis.br Fone/Fax.: (51)32303328
В списке pgsql-jdbc по дате отправления: