Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Keiran Kainth
Keiran Kainth
21,105 Points
Posted by Keiran Kainth
Keiran Kainth
21,105 Points

is this a bug? as the results in the table display correctly...

Hello,

Is this a bug please?

https://teamtreehouse.com/library/reporting-with-sql/working-with-text/concatenating-text

The coding challenge in the link above states "You're missing the angle brackets around the email address" when the following code below is entered:

SELECT first_name ||" "|| last_name ||" "|| email AS "to_field" FROM patrons;

The code returns the correct results required in the table 'visually' , but nothing in this course has mentioned about the email data itself needing to contain angle brackets? Or, how to put them in if so?

I'm unsure as to why the task won't pass because of angle brackets not being wrapped around the email?

Regards,

Keiran

1 Answer

Tobias Helmrich
Tobias Helmrich
31,603 Points
Tobias Helmrich
Tobias Helmrich
31,603 Points

Hey Keiran,

the angle brackets in this case are not for code but for the formatting of the email address. It should be formatted like 

<andrew@teamtreehouse.com>

with an angle bracket in front of the email address and one after it. So you have to concatenate the angle brackets and it should work fine!

Like so:

SELECT first_name || " " || last_name || " <" || email || ">" AS "to_field" FROM patrons;

I hope that helps! :)