On Saturday 18 September 2010, HeisenbergsUncertaintyThizz wrote:
> Currently, I have an Articles page which creates articles in a DB.
>
> What I would like to do is to return the ID of the submitted article.
>
> I know how to do it with raw sql,
>
> "INSERT INTO test (name) VALUES ('My Name 1') RETURNING id; "
>
> but I was wondering if there is a way to do it, "The Rails Way".
You just do
@article = Article.create!(...)
and @article will have the correct ID. Internally, the postgresql
adapter uses RETURNING if it is supported by the PostgreSQL version (>=
8.0.2 or something).
If you're interested in the details, read the code in <gem
dir>/activerecord-3.0.0/lib/active_record/connection_adapters/postgresql_adapter.rb
Michael
--
Michael Schuerig
mailto:[email protected]
http://www.schuerig.de/michael/
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
